kevlray
Registered User.
- Local time
- Yesterday, 19:21
- Joined
- Apr 5, 2010
- Messages
- 1,046
Unfortunately some staff members created an Access DB on a shared network drive, the dtatabase has linked tables to an MS-SQL database. At one point the database became corrupted (I was able to fix it by copying the DB to another directory and opening it from that location and saved it back). But the staff just wants that DB deleted (they have started using another copy of the database in another folder).
The issue is that there still is a locked Access file (.laccdb) that is in use by another application. We had the 'original' user whose name is associated with the lock file go into the Access DB and exit (I was hoping that it would delete itself). But alas, it is still there. Any suggestions on how to delete the lock file and the .accdb file? I also am in discussion with them to have each user have their own copy of the DB and not open it from the shared network drive.
The issue is that there still is a locked Access file (.laccdb) that is in use by another application. We had the 'original' user whose name is associated with the lock file go into the Access DB and exit (I was hoping that it would delete itself). But alas, it is still there. Any suggestions on how to delete the lock file and the .accdb file? I also am in discussion with them to have each user have their own copy of the DB and not open it from the shared network drive.