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