Had some help from the Access development team identifying controls added by later versions that aren't recognized by earlier ones. Also cleans up corruption caused by Name AutoCorrect and clears the default printer info stored with all forms and reports. I originally wrote this to fix the AutoCorrupt problem, but added code to strip out controls built by 2010 and 2013 that aren't recognized by 2007 and earlier.
Brilliant John.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, November 06, 2015 7:51 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] HELP unrecognized database format
Its Access 2003 . back end. and front end. the front end links to the be tables.
and was opened with Access 2007 run time version.
will your FixBroken utility help?. and in where is it located.?
Sarah
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Sarah-
You don't say which version of Access you are using. "Unrecognized" can happen if you open a 2007 .accdb in 2010 or 2013 and edit some objects. 2007 won't be able to open the database after that. My FixBroken utility can sometimes repair that, but you have to find a version of Access that will open the database. My utility "downgrades" the forms and reports so they can be opened in 2007 again.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 6, 2015, at 5:57 AM, 'Bill Mosca' wrmosca@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
It sounds like it is toast. If possible, try opening it using Access 2010. If you don't have that I might be able to help if you can send me the zipped file. Depending on its size, you might have to upload it to my website storage. I can give you a link in a private email if that's what you want to do.
EverythingAccess.com does a good job of recovering data from a corrupt database, but they do charge for the service.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, November 05, 2015 3:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] HELP unrecognized database format
yes,
I tried linking the tables and importing to Excel. I get the same message 'unrecognized database format'.
Sarah
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :Sarah
Can you open a new database and link to the tables? Or maybe open an Excel sheet and under the Data tab, try to connect to one of the tables?
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852My Nothing-to-do-with Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, November 05, 2015 11:37 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] HELP unrecognized database format
I get the following message when trying to open an Access 2003 back end db:
'Unrecognized database format'.
The database contains tables and data only.
I have tried compact and repair, importing the tables to a new blank database, but no matter what I try, I get the same message:.'Unrecognized database format'.
I downloaded 'basCompactUtility.bas' from WRMOSCA , but it also gives me the same message.
Is there any utility to repair this db?. The customers last backup is from August (!!!).
Thanks for all advice
Sarah
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar