i have a database in Access, connected to ASP pages using ADODB, and now i want to create another database in SQL Server 2000, same fields' name, same architecture, but just different format.

Is there any way that i can convert my current database from Access to SQL2000 WITHOUT much altering any line in my ASP page (syntax-wise, of course i'll have to rename the database in the ASP page)

if yes, how, if no, how do i do it?

thanks a lot in advance

chris