(Updated 2010/10/23)
Make a backup! Before doing anything else. Preferably on another computer or CDR as a there is a slight possibility the hard drive in question is failing. A successful repair isn't sufficient to ensure your data is clean. I've personally seen a 120 Mb backend MDB repair just fine but both compacting and importing caused Access to puke on the same table. We had to restore from last nights backup. So you must compact it after repairing to ensure it's clean. Importing all the objects, the relationships and the relationships window layout into a new MDB would be even better. Also see After successful repair import into new MDB Stupid Question - "Unrecognized database format" Do you have multiple versions of Access installed on your system? If
so you might be opening a newer format of Access MDB in an older version of
Access. For example you are attempting to open an Access 2000 format MDB
using Windows Explorer. But if you last used Access 97 it will attempt to
open the MDB. More infoSome corruption symptoms
|
|
Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks.
Granite Fleet Manager - the best designed fleet maintenance tracking and management system available
Comments email Tony | Search | Contact | Tony's Blog | Privacy Policy | Table of Contents |
Website copyright © 1995-2013 Tony Toews |