[AccessD] Access ade 20 User limit?

Hi Dan,

The application is run through terminal server and is not housed on 
their local PC's.  We could make individual copies for them all and 
automate the updates but I am all for keeping it simpler if possible.

SQL shouldn't be a problem - we have about 27 licences.   Does anyone 
know of any SQL limitations for concurrent users?

David

At 12/03/2009, you wrote:
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com