why does Autocad not release the access database lock file when closing Autocad
To protect the attached file from 'unauthorized' changes by others. Unauthorized changes may adversely affect the work (such as a query) the original 'attacher' is performing.
Sorry, but it's the responsibility of the 'attacher' to release the lock, not the other user who wants to use the attached file.
Example:
A user with an attached file is working on a drawing. He leaves his desk, e.g., goes to to the conference room for a meeting OR has lunch across the street OR goes to the restroom. Prior to leaving, he saves his work. Eventually his computer goes to sleep and the lock is released. Meanwhile, another user unknowingly and unintentionally, opens the attached file and makes changes to it. When the original user returns to his desk to reconnect, his work is messed up, seriously messed up.
Everyone, understands, it's not a perfect system. Something, though, must be in force to protect the original user's investment in his work.
Chicagolooper
Hi,
>> when I attach an access file to a drawing
There exist multiple ways to connect an Access-file to a DWG using Map 3D functions.
One is: you are using FDO (command _MAPCONNECT) .. I have tried not AutoCAD Map 3D 2022, used command _MAPCONNECT ==> ODBC ==> connect with a connection string ... and at the moment I close the dwg-file the lockfile from the Access-file is removed.
Another one: you are using _DBCONNECT with "Micosoft OLE DB Provider for ODBC Drivers". With this type of connection for me it's similar, either closing the connection or closing the drawing also removes the lock file.
So either you are using different AutoCAD Map 3D version (and/or different installed updates) or you are using a different workflow/different commands or it might depend on different file types or permissions for your OS or for your storage location.
I have tested these 2 workflows with Map 3D 2022 (AutoCAD 2022.1.1 and Map3D 2022.0.1), with MDB as filetype, Windows 11 as operating system, files all stored locally..
- alfred -
Can't find what you're looking for? Ask the community or share your knowledge.