database opens as read only

[harryklein]

Hi,
I need to maintain an excel-vba application that connects to an access db (o365).
The problem I am facing is that I cannot update the record via adodb. ("Current recordset doesn't support update...").
When I open the accdb file manually, I get the messages that it is a read-only, I need to save it under a different name to update.
That's fine, but when I try to do so, I got a message that it is opened by myself, therefore it cannot be saved.
I made a copy of it, and tried to delete the original one, but I couldn't.
I use otherr accdb files from the same location, so I have access for the folder, and the file itself is not read-only on filesystem-level.
How could I manage to have this DB with no read-only protection?
Thank you

[CJ_London]

it may be you have code that has opened the db but not closed it - so access thinks you are still in it. Try rebooting

[harryklein]

Yes, it resolves my problem for one run, but you're right, the root-cause will be some coding issue.
Thanks anyway.