Access Databases

Hi all,

I have a question on an earlier thread that was posted. Couple people said that an access database could only handle aprox. 7 concurrent connections to it at any given time despite MS saying it can do 255.

No problems there, I agree. But is this really an issue? Most of my database connections open and close in under 1 second. That would mean that I would have to have 7 people a second on the website.

There are 79,344 seconds in a matter of 24 hours. If you take that and multiply it by 7 then you have 555,408. That would mean I could (in a utopian world) get 555,408 hits a day and have no problems.

Even if i take that number and cut it in half due to peaks, spikes and what not. That is still over 250,000 hits a day.

My reason for this is I have been asked alot to "just use an access database" due to the fact that my employeers know access and would like to be able to understand the database. Not my problem, they sign my check...

Just wondering, chime in if you have any comments...

Hi

there are few things yoy need to understand when you say
concurrent users is the users connected to the database
at this instance

you are connected to the database till you dont close the
connection now what i mean here is
you need to open the connection , query the database ,
display or process the data and then close the connection

as far as 555,408 hits a day are concern we assume that
there are no more than 7 people connected to the database
at the same second. ...... hmmm

i shall also advice to to look at MSDE which is almost like access
but more robust and powerful ( but the disadvantage is you cant have more than 5 concurrent connection) but then you can any time port you application to SQL Server

hope this help

cheers
jayesh jain

Hey, thanks for the reply.

I understand that a connection is defined as a time in which the database is open until the database connection is closed. I have timed a few of my pages and they process in about .40 milliseconds.

Therefore, in a PERFECT world @ 7 connections per second you could handle a great deal of traffic before having to upgrade.

Again, the reason for not upgrading right off the bat is at the request of my employeer.

Thanx,

there is only one problem, when you upgrade to another server because of high levels of traffic, it may cause some problems, sometimes its best to think 'big' and think of the future a bit, using another database now, could save you some problems later