Can't open database

[jpl458]

AS i make changes while developing, I save the data base, then after a point I save it as a different version. I just made some changes to the latest version, and closed ACCESS. The when I try to open the version It starts to open the goes away. If I retry it tells me I need to make a backup, but, when I do it says that one already exists. If I can't open it how do I repair it, or is that not an option.

 

[Ranman256]

sometimes opening a different version can cause problems in the REFERENCES.
Enter VBE (alt-F11), tools, references,
see if anything checkmarked says MISSING. uncheck it, and scroll down to load the correct version.

then compile it (in VBE): menu, debug, compile.
any errors show?

 

[CJ_London]

When it offers to make a backup you usually get the option to change the name - add a suffix for example.

can also try opening it while holding down the shift key (unless you have disabled it) which stops any code from running

 

[The_Doc_Man]

Outside of Access, make a file copy (copy/paste) through the Windows Explorer window. Rename the copy and move it somewhere into another folder. Then open Access from the start menu, not pointing to a particular file. You can still activate a compact & repair from the File tab. It will ask you for the file to C&R. If this fails or otherwise blows up in your face, you still have that binary copy made via Explorer.

Another thing you can do, and perhaps you should try this even before the "external" C&R, is to do a DECOMPILE. See this link:

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

www.fmsinc.com

 

[jpl458]

Outside of Access, make a file copy (copy/paste) through the Windows Explorer window. Rename the copy and move it somewhere into another folder. Then open Access from the start menu, not pointing to a particular file. You can still activate a compact & repair from the File tab. It will ask you for the file to C&R. If this fails or otherwise blows up in your face, you still have that binary copy made via Explorer.

Another thing you can do, and perhaps you should try this even before the "external" C&R, is to do a DECOMPILE. See this link:

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption

www.fmsinc.com

It happened again and I am following your repair instructions. I've moved the database into a different folder and renamed it. I open ACCESS and there is a list of the versions that I have. I go to open>This PC and navigate to where the copy is but ASSECC does not see it. It says "No items match your list". Then I copied the URL for unfurl, and I get a page not found in the browser(Chrome). what bothers me is that I was using that database last evening and it working fine. I try to open it this AM and boom.

 

[The_Doc_Man]

When you renamed the file did you by chance not keep the correct file type? Asked another way, when you look at the folder where you put the copy, does it show the Access icon or an ordinary file icon?

 

[jpl458]

It happened again and I am following your repair instructions. I've moved the database into a different folder and renamed it. I open ACCESS and there is a list of the versions that I have. I go to open>This PC and navigate to where the copy is but ASSECC does not see it. It says "No items match your list". Then I copied the URL for unfurl, and I get a page not found in the browser(Chrome). what bothers me is that I was using that database last evening and it working fine. I try to open it this AM and boom.

I figured out how to find it, used browse rather than open. but it keeps telling me Unrecognized database format C:\Users\jplor\OneDrive\Desktop\Robdata\V-12Recoovery\rocoverv_12accdb when I try to open it. I think I just learned to do D&C often on the database.

 

[LarryE]

Is the file name supposed to be rocoverv_12.accdb? Because I noticed according to the file location you posted, you are looking for rocoverv_12accdb with no .accdb extension.

 

[Gasman]

I figured out how to find it, used browse rather than open. but it keeps telling me Unrecognized database format C:\Users\jplor\OneDrive\Desktop\Robdata\V-12Recoovery\rocoverv_12accdb when I try to open it. I think I just learned to do D&C often on the database.

You have lost your extension?

 

[jpl458]

When you renamed the file did you by chance not keep the correct file type? Asked another way, when you look at the folder where you put the copy, does it show the Access icon or an ordinary file icon?

I got it to work, using your method. After I moved and renamed the database I was trying to open it via ACCES, and there was no joy in front of my PC. After mulling on it, I created a folder on a different drive, made a copy of an earlier version and open it by clicking on the DB itself in the folder. Did a repair and it worked. I then took one on the bad DBs did the same thing and everything went well. Lastly I took the latest version, did the same stuff, and VOILA, the presence of joy appeared about me . Many thanks for the help, Doc. Saved a lot of work, and learned something in the process.

 

[jpl458]

More mulling...Wondering why I couldn't open from ACCESS start screen, but could, after move, by just dbl clicking the entry in the new folder. What happens in ACCESS to cause this in the first place?

 

[The_Doc_Man]

Just as a guess, after moving to another folder, you moved away from the lock file. Do you have an .laccdb file in that original folder? If so, the lock file was corrupted.

 

[cheekybuddha]

You never answered posts #8 and #9.

 

[jpl458]

Just as a guess, after moving to another folder, you moved away from the lock file. Do you have an .laccdb file in that original folder? If so, the lock file was corrupted.

Yes I did have .laccdb.

 

[jpl458]

You have lost your extension?

Found out it was .laccdb. Doc said it was a corrupted lock. All fixed now.

Thanks

 

[The_Doc_Man]

Yep, if you are not in the DB but the .laccdb file hangs around, that can become really problematic. Fortunately, if you delete that file, it should all reset itself. If you CAN'T delete the file, you might have to reboot, but afterwards the file can be deleted.