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
pdvsaProject financeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Darrell PorterEnterprise Business Process ArchitectCommented:
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?
0
pdvsaProject financeAuthor Commented:
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
0
pdvsaProject financeAuthor Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

pdvsaProject financeAuthor Commented:
OK here is the complete path:

C:\Users\pdvsa\Documents\Personal\Computer\contact list management
0
pdvsaProject financeAuthor Commented:
<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.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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:

http://www.experts-exchange.com/Database/MS_Access/Q_28450832.html

If none of those work, you're probably left with a recovery service, like www.everythingaccess.com.
1
pdvsaProject financeAuthor Commented:
Scott,

Thank you.
Question:
<You can also try the SaveAsText/LoadFromText method listed here:
<http://www.experts-exchange.com/Database/MS_Access/Q_28450832.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:
Error Message
0
pdvsaProject financeAuthor Commented:
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"
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?  
From within the corrupted db, if you can. In many cases, the corrupted database is too far gone to run VBA Code like this, which would (unfortunately) mean you're pretty well left with a recovery service.

CurrentProject.Path is the actual path to the current project file. The SaveAsText you posted above would save the "Contacts" form to a file named "Contacts.txt" in the same folder as your Access file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pdvsaProject financeAuthor Commented:
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.
0
Helen FeddemaCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.