Forum Discussion
question about access microsoft 365
I am sorry - i solved my own problem. the table was not sorted correctly - i actually found those entries from yesterday and then got it working. I have had a persistent problem however that is worrisome. I cannot do the compact repair function at all - it keeps telling me that "file is in use" - I liked to do this function periodically. can't anymore.....
NancyLWein Congratulations on resolving that mystery!
There are a couple of possible things to consider, but the most likely one is that the accdb was closed abnormally, leaving behind the locking file, i.e. the "lccdb". Normally, locking files are deleted when you close the accdb, but if something goes wrong, it can be left behind. And then it can indicate to Access that "someone else" has it open still, even though that's not the case.
If this is on your own computer, one strategy that usually works is to reboot, then manually delete the orphaned lccdb BEFORE starting the working accdb again.
If it is on a shared computer, of course, it's more complicated in that you have to have the administrator of the LAN do the reboot and possibly delete the lccdb for you.
If that doesn't work out, let us know. That's the most likely reason, although not necessarily the only one.
George Hepworth And please do make sure your backup protocol is working correctly. There's nothing worse than losing unbacked up data.
