Avatar of pdvsa
pdvsaFlag for United States of America

asked on 

Unrecognizable database format

Experts,

i get the following error when opening the db.  
I have tried to compile and get the same error and also tried to import all into another new clean db to no avail.

What should I do?

thank you
Microsoft AccessVBA

Avatar of undefined
Last Comment
Helen Feddema
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

What is the full name and path of the database file and how are you trying to access it?  Are you opening Access and then trying to open the database file or are you double-clicking on the database file?
What version of Access are you using?
What version of Access did the database come from?
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

I think the picture did not attach that showed the error or at least it doesn't show on my phone.   The pic showed the entire path.  I am away from the computer at the moment but will be back in 30 min.  

I am using 2010.  I was passing the file between two computers: 1 with 2010 and other I think 2013 (whichever is the next latest version after 2010).  The file was fully developed though but I added contacts here and there but no modifications from what I can remember.  I am not using the other computer now tho and now I get the error.

Let me know what is next
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

It was initially developed in 2007 and was contacts DB template.  I have been using it in 2010 and 2013 without any issues until I stopped using the 2013 computer.
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

OK here is the complete path:

C:\Users\pdvsa\Documents\Personal\Computer\contact list management
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

<Are you opening Access and then trying to open the database file or are you double-clicking on the database file?
==>I tried it both ways.
Can you show the exact error you're getting?

You might try a Decompile. Make a backup, then create and run a Shortcut with this as the Target:

"full path to msaccess.exe" "full path to your db" /decompile

After decompiling, try to Compact - Compile - Compact again.

If those don't work, it's possible you have a corrupt Form or Report. Try importing your objects one-by-one into a new, blank database. If you have one that's corrupt, Access will alert you when you try to import it. If so, you could import everything else, and then restore the trouble object from a known good backup.

You can also try the SaveAsText/LoadFromText method listed here:

https://www.experts-exchange.com/questions/28450832/SaveAsText-all-forms-or-objects.html

If none of those work, you're probably left with a recovery service, like www.everythingaccess.com.
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

Scott,

Thank you.
Question:
<You can also try the SaveAsText/LoadFromText method listed here:
<https://www.experts-exchange.com/questions/28450832/SaveAsText-all-forms-or-objects.html

Is the SaveAsText method to be used from within the corrupted db or do I run it from the immediate window from within another blank db?  

I tried the decompile method before posting this question.  I received the same error.  
I can open up a backup though but it is not current.

here is the error:
User generated image
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

Also, is the "CurrentProject.Path" suppose to be the path to the file or do I leave as is?
SaveAsText acForm, "Contacts", CurrentProject.Path & "\ Contacts.txt"
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

Ok thank you.  Since I can not open the corrupted DB nor import any objects not compile it seems like my only option is a data recovery service as you mentioned.
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

There were format compatibility problems between 2007 and 2010.  See my Access Archon article on this topic, which discusses various approaches to fixing the problem:

http://www.helenfeddema.com/Files/accarch205.zip
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo