Converting Access to SQL Express 2005

ish

Hi m8

I have developed small office web base application, where user Insert, update and delete data. Currently it has Microsoft Access 2003 backend database. I am having a small problem. It is bit slow and multiple users are having problem inserting or deleting data at the same time.

So I am thinking to upgrade to Microsoft SQL Server Express 2005. Will I be able to used all my sql query and sql statement i have build in the asp page. Or Do i have to change every thing.

Please can you help.

many thank

snow

SQL is for the most part a standard syntax - especially between the Microsoft DB products. Nothing in your code should have to be changed.

However you might want to consider using stored procedures aftter you complete the upgrade:
http://databases.about.com/od/sqlser...dprocedure.htm

Faster and are really great for security, especially avoiding injection-attacks:
http://msdn.microsoft.com/msdnmag/is.../SQLInjection/

If you need any help with the configuration or change-over we're only a post away!