A2K, Different OS's, Maximum Users?

[roxannep]

I have a client that I support who called asking what their maximum number of users is for their Access 2000 dbase. They have had no problems with the dbase until just recently. Today they started receiving a message that it could not allow any more users on (unfortunately no one wrote down the error code for me).

The only changes I can identify readily are that most of their PC's are running Win98, and Office 2000. However, a recently new user is running Win98 and Office XP and is logged in simultaneously.

We are looking to split the database because they have now moved it to a server, and I discovered they are running the whole thing over the network (not just the data, but queries and all).

At any rate, they have 9 users that can access it, but have 11 users that need to, and apparently received an error today that they could log no further users in.

Suggestions? The size of the dbase is currently about 17mg.

Thanks for any help or insites as to how to enable them to get 11 folks on.

Roxanne

 

[gusbrunston]

Hi.

All the info I read says maximum number of users 255. Also, that after ten or so, one should consider upsizing(?) to an SQL server.

Another thought: in Windows 2000 Pro when you select a folder to share, it gives you the opportunity to select the maximum number of users. Could it be that the limit for your client is not set in Access but in the operating system? We have one user with Windows 98 and that one gives us almost all operating system problems.

If they'd return to a frontend, backend configuration, they'd be better off. You can tell 'em I said so.
Gus Brunston An old PICKer, using Access2000. Celebrating this year my 72nd birthday and my 50th wedding anniversary.
padregus@attbi.com

 

[roxannep]

Thanks for the suggestions.

First, I, too, found that information on concurrent users (255).

Second, I found out my client's employees don't have a clue what the difference is between a server and their main Access database. They reported back that the message says the SERVER could log no one else on, NOT the database (turns out they need to upgrade their server software license info.).

Mystery solved. But I have recommended they all have the same OS whichever they choose and the same version of Access so we don't run into problems from that end.