Access Tables to SQL-db

[Jack Daniels]

Hi!

I have an access db, I would like to convert the tables and place the tables in an SQL-server db. but I still want to use my application, forms, querrys, and reports. Is this possible and in this case, is it easy or is there a better way? How do I do?

Jack

 

[Sergeant]

The Upsizing Wizard in Access can do this for you, not sure if all versions are supported. I just installed SQL Server 2005, and it is far less compatible with Access than previous versions were. I didn't try the upsize wizard, but SQL 2005 won't let you build or alter tables from Access.

 

[Smart]

You could export your tables to the SQL server
in your code in the access datadase you will have to connect to the SQL server so that you can see your tables. Your code in your forms etc will need to be amended as some vb code in access is not usable in SQL Server.