Number of concurrent users

[credo]

Hello,
My MS Access database driven website has got 39 concurrent users trying to query (read only) the db. I'm getting the error :
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

I've had 23 users querying the db at one time and it was ok - so is it just a case of MS Access not being able to handle more ? ie. I'm assuming when the number of users drops down the db driven web pages will be ok again automatically ?Is this correct ?

thanks
______________________
Credo

 

[scking]

Verify your ODBC drivers at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q140548

Access shouldn't be limited to that low number of users. You never did say which version you were using.

Steve King Growth follows a healthy professional curiosity

 

[credo]

thanks scking - I'm using Access 2000 - I will have to check with my webhost providers what version of the ODBC driver they are using.

Is it correct to assume then, that I can have more than 40 users querying the db at the same time through web pages ? I always thought it was lower than this - I want to avoid upgrading to SQL Server 2000 or SQL Server 7 if possible.