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
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