I first started my website using the access database with very little data in it. It is normalized up to 2NF. After almost a year of running the site, the number of records have grew from hundreds to tens of thousands. Right now the site is still functioning ok, but I have a feeling it is going to crash on me soon.<BR>I am planning on switching the Access database to SQLServer. I have read some articles on using the upsizing functions in Access. However, does SQLserver have same SQL syntax as Access? Is there anything I should watch out for? I cannot afford to have my site down for over 2 hours.<BR>Thank you in advance.