In which (really) important ways is SQL 2000 better than Access 2003?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,946 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,885 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 2376 | Replies: 0

•

Join Date: Jul 2005

Posts: 7

Reputation: jeffy1 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jeffy1

Offline

Newbie Poster

In which (really) important ways is SQL 2000 better than Access 2003?

Sep 19th, 2005

I have developed some webpages using asp and they work fine on my computer with Access 2003 (using iis as a local server). However, I am aware that SQL 2000 is a better db to use, but I am not sure in which ways.

Since I intend to put my asp pages on a webserver I wonder what the advantages for me (if I use SQL 2000 instead) would be. The areas I am most interested in is the maximum number of users that the two databases can handled at one time and of course security issues.

Would my database be better protected against hackers etc. if I go with SQL 2000 instead?

Other important differences?