P
Penny
Here is a real head scratcher.
Background:
I have an Access 2002 (saved in 2000 format) database
that is accessed over the web using the Citrix
(emulation) program. It is currently being accessed by
only 6 or so users. The server which houses the program
has apparently installed all the proper Windows and
Office updates, etc.
It is a pretty involved database with lots of VB code.
Upon opening, the user's login is linked to a table in
another database. A valid login will then open a specific
form depending on who the user is and what position
he/she holds.
Each of the current users access the same queries and
tables except that the data is filtered so they only see
data pertinent to their own region.
The database's open mode is set to shared, record locking
is set to no locks and the open databases using record-
level locking is unchecked.
Problem:
As some users are using the database experiencing no
problems, other users try opening the file at the same
time and get the message that the database needs repair
or isn't a database. When they click Yes to repair, of
course, the error that says they do not have exclusive
use comes up. Now mind you, the first users are still
simultanously using the db just fine. However, if one of
them closes and tries to open again, he/she gets the
needs repair message and consequently can't get in again.
Once everyone closes and someone goes in to do the
repair, then everyone can get back on and use it just
fine.
This does not happen all the time, a couple times a day
maybe. We cannot establish a pattern except the we
replaced one of the older computers that tends to lockup
anyway and we thought there might be pattern when users
were printing or were inactive but none of these patterns
holds true all the time.
Can anyone shed any light/suggestions?
TIA
One Baffled Programmer
Background:
I have an Access 2002 (saved in 2000 format) database
that is accessed over the web using the Citrix
(emulation) program. It is currently being accessed by
only 6 or so users. The server which houses the program
has apparently installed all the proper Windows and
Office updates, etc.
It is a pretty involved database with lots of VB code.
Upon opening, the user's login is linked to a table in
another database. A valid login will then open a specific
form depending on who the user is and what position
he/she holds.
Each of the current users access the same queries and
tables except that the data is filtered so they only see
data pertinent to their own region.
The database's open mode is set to shared, record locking
is set to no locks and the open databases using record-
level locking is unchecked.
Problem:
As some users are using the database experiencing no
problems, other users try opening the file at the same
time and get the message that the database needs repair
or isn't a database. When they click Yes to repair, of
course, the error that says they do not have exclusive
use comes up. Now mind you, the first users are still
simultanously using the db just fine. However, if one of
them closes and tries to open again, he/she gets the
needs repair message and consequently can't get in again.
Once everyone closes and someone goes in to do the
repair, then everyone can get back on and use it just
fine.
This does not happen all the time, a couple times a day
maybe. We cannot establish a pattern except the we
replaced one of the older computers that tends to lockup
anyway and we thought there might be pattern when users
were printing or were inactive but none of these patterns
holds true all the time.
Can anyone shed any light/suggestions?
TIA
One Baffled Programmer