J
JR_06062005
I have an Access application sitting on a shared server. The data tables
site on an SQL server and are linked to the Access application. There are
about 50 users. It seems that when the application is in heavy use, users
have a difficult time getting into the application. They get the message
that the application or database has been locked by the administrator. I am
the adminstrator and most of the time when a user gets this message I am not
even in the application. In fact some user will be identified as locking the
database. A fix I've recommended for those locked out is to log off their
PCs and log back on again. Most of the time this works, but not all the time.
My theory is that Access has reached it's capacity for number of users for
the application as configured/written and will not let in additional users.
I thought that having the data actually on the SQL server rather in Access
would help, but it appears not enough. Any suggestions to solve this
problem will be appreciated.
site on an SQL server and are linked to the Access application. There are
about 50 users. It seems that when the application is in heavy use, users
have a difficult time getting into the application. They get the message
that the application or database has been locked by the administrator. I am
the adminstrator and most of the time when a user gets this message I am not
even in the application. In fact some user will be identified as locking the
database. A fix I've recommended for those locked out is to log off their
PCs and log back on again. Most of the time this works, but not all the time.
My theory is that Access has reached it's capacity for number of users for
the application as configured/written and will not let in additional users.
I thought that having the data actually on the SQL server rather in Access
would help, but it appears not enough. Any suggestions to solve this
problem will be appreciated.