Access to SQL server

date posted 15th January 2003 12:58

hi people,

I recently built a site for a client using access and asp [through I did
suggest at the time that this could prove problematic further down the line]
the client now want to upgrade the database to SQL Server.

Having never done this before I found a few tech tips etc for exporting the
data, but am wondering if any one can give me any pointers on the following:

a] will I need to make changes to general SQL code that is employed in the
pages, such as select, insert, update etc?

&

b] I have used queries in a number of cases in the access database - can I
still use these in SQL Server?

any help or pointers much appreciated,

cheers

Tim