pcc
Well-known Member
- Joined
- Jan 21, 2003
- Messages
- 1,353
I am trying to see if a database is in use or not, but only have Access 97 so the links posted by C T Witter are no use. (Post from Access forum, sorry I have mistakenly posted this to the Access forum and meant it to go here )
http://www.mrexcel.com/board2/viewtopic.php?p=1118358#1118358
I like Norie's suggestion of lookng for the .ldb file. This works fine when the access database is read-write, and I have implemented this idea.
However, I have several databases that are in a read-only folder (with me being the only read-write person). In this case the .ldb file is only created when I connect to the database: for others there is no file created.
Whilst the code I provide connects them to the database in read-only mode, I still get occasional errors if more than one user is reading the data at the same time. I would like to see if the database is being read, and if so, put a loop in the code that waits until it is not, thus avoiding simultaneous access by >1 person. Any ideas how to accomplish this with a read-only databse
http://www.mrexcel.com/board2/viewtopic.php?p=1118358#1118358
I like Norie's suggestion of lookng for the .ldb file. This works fine when the access database is read-write, and I have implemented this idea.
However, I have several databases that are in a read-only folder (with me being the only read-write person). In this case the .ldb file is only created when I connect to the database: for others there is no file created.
Whilst the code I provide connects them to the database in read-only mode, I still get occasional errors if more than one user is reading the data at the same time. I would like to see if the database is being read, and if so, put a loop in the code that waits until it is not, thus avoiding simultaneous access by >1 person. Any ideas how to accomplish this with a read-only databse