Switch from access to Sql Server

[hpvic03]

Alright, so I'm looking to build a website that will have a lot of users. In the past I've always used access, but I have been reading things saying it will not work with a lot of users all at once. So I've already built my beta version with access, and so how do I switch to a microsoft sql database? Anyone know of any articles or tips? Will I need to re-write my queries?

Help is appreciated!

 

[r937]

at a minimum, you will have to examine every query

changes will be necessary for date functions, substrings, joined updates, and several other differences

r937.com | rudy.ca