Hi,

I want to convert a Access application to SQL server 2005 application?
Do I have to convert all queries to stored procedure?

Thanks

Mark

I've successfully used the Upsizing wizard on the tables. You do not have to convert queries, no.

Hi Paul,

I use DAO in Access 2003 now,Do you think if I need change some VBA codes manully?Thanks

Mark

No; DAO will work fine with SQL Server. ADO is probably better optimized for it, but DAO will work fine.