Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

upsize Access to SQL Server, what is the process?

Status
Not open for further replies.

marks416

IS-IT--Management
Oct 24, 2007
39
CA
Hi,

I plan upsize my current Access application to SQL server 2005 application.I hope the front end is same and no change and just move the database to SQL Server.

My current Access application use DAO to access database.I want to know if DAO can work with SQL server.

I found the upsizing wizard in Access.Do you think if the upsizing wizard can do everything for this?

Do I need manaully change the VBA codes? Do I have to use ADO to access SQL Server?Please give me a hit.

Thanks for help

M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top