Apr 28 2022 02:43 PM
Hello. This may be a silly question, but how do you unlock Access databases? Each time I open a database, in my file explorer there is a second file that opens and has the extension .laccdb. I cannot complete some of my assignments for school because of this.
I hit a wrong button about a month ago, which started all of this. The laptop is my personal laptop, and I am not sharing any files.
Any help with this issue would be greatly appreciated, please.
Apr 28 2022 02:45 PM
Apr 28 2022 02:50 PM
Apr 28 2022 03:02 PM - edited Apr 28 2022 03:03 PM
Ah, that's clearer. This .lccdb file has nothing to do with the problem itself, then.
When you say you want to "create a back up of the file", are you referring to the .accdb itself? Or something else?
Also, HOW do you go about creating that backup? Step by step is better.
Apr 28 2022 06:16 PM
I cannot reply with any certainty, as I am only learning Access. We were in class and trying to save a backup of the 2002-2003 version, so we could "send" it to someone who has a later model of Access. When I finish the steps (going into the File tab, click on "save as", choose the Access 2002-2003 Database), and hit Save As, a message comes up telling me that the file is in use on my computer, so I cannot save it. It happens at other times as well, when trying to save different things. This afternoon it happened when I was trying to create a look-up list in one of the fields. There were no other versions of the file open, but I was getting a message that there was.
Apr 28 2022 06:24 PM
Apr 28 2022 06:26 PM
Unfortunately, it's almost impossible to trouble-shoot problems such as this on a computer we can't see.
The more details you can provide (the more specifically you can describe factors) the more likely we'll be to be able to offer useful suggestions.
So some things we'd need to explore.
What version are YOU using here to save to the Access 2002-2003 version? The exact error message said that the Access file itself was in use? Is this the same one you have open at that moment? Are you trying to save over the top of an existing mdb file? If so, is it open?
Screenshots go a long way towards helping us see and understand the situation.
Apr 28 2022 06:33 PM
Apr 28 2022 08:49 PM - edited Apr 28 2022 08:57 PM
Corrected....
Yes, the .lccdb is part of the standard process of using an Access relational database applications. It is ALWAYS created when an accdb is opened in shared mode. Normally you do open the accdb shared, unless you specifically open it in exclusive mode. It was probably there before, even if you hadn't noticed it until recently. I suppose that, if you had only opened it in exclusive mode, it wouldn't have created the .lccdb, but that's going to be a deliberate choice.
You WANT it to be created. Please do not try to delete it manually as that can result in serious problems, even corruption of the accdb.
It won't be part of the problem you noted, unless you meant to save IT (the lccdb) under a new name, in which case that's a problem to be avoided and shouldn't be attempted.
I'm still not clear on what the actual problem would be, though. You said you tried to save the accdb as an Access 2002-2003 mdb, and the error message was that the file was in use. I can't replicate that, although OTHER errors are possible. That's why I want to see the screenshots for clues as to what else might be going wrong in that save process.
Apr 29 2022 08:13 AM
Apr 29 2022 09:23 AM