How powerful MS Access 2000 database is?

[Faheemi]

Hi there,

I am going to create a website which involves a database component which is MS Access 2000. I use the database only for querying. No additions or deletions. The site will actually be a low hit site that at one time not more than 9 to 10 people querying the database. What I wanted to know is how powerful the MS Access 2000 database is? How many simultaneous query hits it can withstand?

Thank you for all of your input on this.

Thanks again.

Faheem Hameed

 

[therealeasterbunny]

I think (although I could be wrong) it might depend also on what you are using to access the MDB ... ODBC or DSN-Less etc. I have an Intranet with 1500 users and a telephone directory in Access using DSN less conection via VB Script (ASP Pages) and have not yet had any reports of it giving issues.

 

[BNPMike]

Access has two databases - Jet and SQL Server (alias MSDE). Both of these are complex and very sophisticated. You should be alright - just remember to put an index on anything that moves and reorganise your database everytime you change it.

If you choose MSDE (which is actually optimised for a max of 5 current sessions) you can always upgrade to the full SQL Server in which case you can handle 10000 users. mike.stephens@bnpparibas.com

 

[tlbroadbent]

You can't legally connect to MSDE from a website. It isn't licensed for the Internet. With SQL 2000 you must have standard or enterprise edition with processor licensing to allow web access to your datasbases. SQL 7 requires an Internet Connector license.

The best choice for connecting to the Access database is ADO. You don't need to install Access on the web server, just the MDAC components. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Faheemi]

I know if we use SQL Server there will be no performance problem. But it is a bit expensive. That's why I am looking at MS Access 2000. I want to make sure that the MS Access 2000 withstands atleast 10 concurrent hits(just queries) on a database with a few hundred records (around 4 hundred records).

Hi therealeasterbunny! it is nice to know that you are using MS Access for a 1500 user intranet site. But can you explain how many concurrent hits you are getting on the database at one time?.

Thank you all for your help.

Faheem Hameed

 

[BNPMike]

Terry

Presumable Faheemi is not actually using Access. Most likely VB Script via ASP. In this event how would MSDE know it was connected to the Internet? Or are you just saying it is illegal rather than non-workable? mike.stephens@bnpparibas.com

 

[tlbroadbent]

Illegal. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[crose7227]

why is it illegal?

 

[tlbroadbent]

Read the Microsoft EULA. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.