Convert Acess 2000 to SQL and ASP Scripts

[vvicin01]

I have a client that I've created many asp scripts to communicate to a Access Database. How can I convert the Access database to SQL and will I need to change any of my asp scripts to communicate to the database?

 

[cmmrfrds]

If you set up your connection object in an include file and included in all your scripts, then just change your connection string.

If you used ANSI standard naming conventions in your Access database tables and used the same names in the SQL Server tables, then just changing the connection string should take care of it.