E
Ed Metcalfe
Hi,
Over the past couple of weeks a number of different developers within the
company I work for have been having problems with their Access databases.
Users have been receiving three different error messages when opening the
systems:
1. You do not have permissions to open this database exclusively.
2. You do not have permissions to open the backend database file.
3. Disk or network error.
The disk or network error also occurs after the users have successfully
opened the system and been using it for a period of time.
All three messages are intermittent. Often retrying immediately after
receiving the message everything works perfectly. Sometimes (particularly
with the disk or network error) you have to wait several hours before the
database can be opened.
When the disk or network error message is received it is not possible to do
anything with the file in Windows Explorer either - it cannot be
copied/moved to another directory or drive. Other files in the same
directory can still be accessed/moved/copied/deleted. We've checked the
permissions on the directory in which the databases are stored and the
permissions on the database objects and everything is fine there.
This doesn't feel like an MS Access problem to me, however we're having
difficulty convincing the people who look after our servers and networks
that it isn't just a problem with the databases. My guess is another process
is intermittently locking the files preventing Access from reading them and
this is what's causing the different messages (disk/network error if the mdb
file is locked, permissions errors on the backend if the mdw is locked, open
exclusive permissions messages if the ldb is locked). I just can't prove it!
Has anyone seen anything like this before? If anyone can shed any light I'd
appreciate it.
TIA,
Ed Metcalfe.
Over the past couple of weeks a number of different developers within the
company I work for have been having problems with their Access databases.
Users have been receiving three different error messages when opening the
systems:
1. You do not have permissions to open this database exclusively.
2. You do not have permissions to open the backend database file.
3. Disk or network error.
The disk or network error also occurs after the users have successfully
opened the system and been using it for a period of time.
All three messages are intermittent. Often retrying immediately after
receiving the message everything works perfectly. Sometimes (particularly
with the disk or network error) you have to wait several hours before the
database can be opened.
When the disk or network error message is received it is not possible to do
anything with the file in Windows Explorer either - it cannot be
copied/moved to another directory or drive. Other files in the same
directory can still be accessed/moved/copied/deleted. We've checked the
permissions on the directory in which the databases are stored and the
permissions on the database objects and everything is fine there.
This doesn't feel like an MS Access problem to me, however we're having
difficulty convincing the people who look after our servers and networks
that it isn't just a problem with the databases. My guess is another process
is intermittently locking the files preventing Access from reading them and
this is what's causing the different messages (disk/network error if the mdb
file is locked, permissions errors on the backend if the mdw is locked, open
exclusive permissions messages if the ldb is locked). I just can't prove it!
Has anyone seen anything like this before? If anyone can shed any light I'd
appreciate it.
TIA,
Ed Metcalfe.