Issue
For some Access database files on IC and Library computers, the file may become locked/in use by the local administrator account while being edited. This appears to be caused by some action in the scripting in the database file, based on the samples we have seen (from a recurring BITM class).
| Tip |
|---|
To avoid this issue, using the Save As command immediately after opening the file may help. It did in one case. |
...
Resolution
With the database still open in Access, go to the folder where it is saved (My Documents, S Drive, etc.)
Tip If you do not know the location, you can find it from the title bar or the File menu's Info section:
- Copy and paste (to duplicate) the .accdb file (not the .laccdb file)
- Open the new "Copy of thefilename.accdb" or "thefilename - Copy.accdb" file to verify its contents
- Rename the duplicate file if desired and submit it as appropriate
...