[AccessD] Access ade 20 User limit?

Dan Waters dwaters at usinternet.com
Wed Mar 11 21:10:06 CDT 2009


Dave,

Typically you'd have 20 different FE's for 20 potential users, one FE on
each client PC.

Perhaps there is somehow a 20 user limit established in the SQL Server BE.
This is just a pure guess though.

Dan



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Wednesday, March 11, 2009 8:11 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access ade 20 User limit?

We have an Access XP ade which will only allow 20 users to 
simultaneously have it open.  The 21st user gets a "Database is not 
in the correct file format" error (or words to that effect).

 From googling it seems that the only solution is to provide more 
copies of the FE so that the limit doesn't get reached.

Has anyone else come across this problem and found a better solution?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list