>Did I have to change all my code to use SQLServer or juste need to change the connection type?
It is very close syntax. It depends on the way you wrote your queries. For expample "Delete * From ..." works in Access but not in SQL Server (it must be "Delete From ...".
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com