How to covert a Access 2000 Application to SQL Server 2005 App.?

[marks416]

Hi,

I need convert an Access 2000 App to SQL Server 2005 App now.

I need use DSN-less connection with DAO because I need save the App in the network and many people use it.

Please give me a idea how to do this and the steps I will take.

Do I have to change a lot VBA codes?

Thanks

M

 

[JerryKlmns]

Use the upsizing wizard and take a look on What are the main differences between Access and SQL Server?