IN THE SPOTLIGHT: MDE to MDB Conversion Service
(also supports: ACCDE to ACCDB, ADE to ADP, etc)
IN THE SPOTLIGHT: Access Database Repair Service
An in-depth repair service for corrupt Microsoft Access files
IN THE SPOTLIGHT: vbWatchdog
VBA error handling just got easier...
" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "
- Joe Anderson,
Microsoft Access MVP
Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)
IN THE SPOTLIGHT: vbMAPI
An Outlook / MAPI code library for VBA, .NET and C# projects
Get emails out to your customers reliably, and without hassle, every single time.
Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.
IN THE SPOTLIGHT: Code Protector
Standard compilation to MDE/ACCDE format is flawed and reversible.
First and foremost, try not to panic. I know it seems, and may very well be, that you have a big problem. However, panic can hamper your ability to fix things and even cause you to make errors that cause more problems. Get a cup of coffee, take a short walk, however you blow off some steam - do so, then come back and begin.
The first thing to try is the Jetcomp utility. If you don't have it, download from Microsoft:
If that doesn't solve your problem, work your way down this table. The flow is down as you answer questions.
| Are you not able to open the mdb or is the mdb open and you can't open a table? | ||||||
| Can't open mdb | Can't open table | |||||
| Can you open any file on this computer? | Is the table in the mdb file you have open, or is it attached? | |||||
| Yes, I can open other files | No, I can not open other files | Table is in MDB | Table is in attached db | |||
| Can you open another mdb on this computer? (Copy in another mdb if necessary.) | Sounds like the computer. Move the files you need, if possible, or just sit back and wait for the computer to get fixed. | Can you open another table in this mdb? | Open (in the database window) the db that actually has the table. Run through these steps again. | |||
| Yes, I can open another mdb | No, I can not open another mdb | Yes, I can open another table in this mdb | No, I can not open another table in this mdb | |||
| Try creating a new db and importing objects, one at a time, from the corrupt db. Still no good? See When All Else Fails, below. | Sounds to me like the server's copy of Access is kaput. Try moving the db you can't open to another computer and see if you have better luck. | Sounds like you've just lost the one table. Create a new db and import all other objects. Create a second new db and try to import the bad table. Try to create a query based on this table - basically, try anything to get at the data for this table, but try it in isolation from all other objects. Nothing? See When All Else Fails, below. | Can you open any object in this mdb? | |||
| Yes, I can open another object in this mdb | No, I can not open another object in this mdb | |||||
| This would indicate the data tables have been hosed. Again, try creating a new db and importing objects one at a time. It may be just one table. Save your most recently used table (if you know) for last. Still no good? See When All Else Fails, below. | Try creating a new db and importing objects, one at a time, from the corrupt db. Still no good? See When All Else Fails, below. | |||||
| When all else fails:
Contact an Access Database Recovery Service
Editorial Note: Read our Access Database Corruption Repair Guide |
||||||
Rate this article: 
TWINBASIC LTD (Company No. 16590181, VAT No. GB497509439)
Terms | Privacy | Sitemap | X (Twitter)
