Software

Ask something
Discussion Locked

Microsoft Access database problem

0 helpful
8 replies

by red dragoon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have got an image database on our file server with a .mdb extension. When I try to open the file, Access starts but I get an error message. It says something like it needs to be repaired or it's not a MS Access database file. First, I created a copy of the file, then I ran the repair utility. After it was done and I tried to open it again, Access just told that it was not an Access database. Help!

8 replies

by chainsawz

You don't say which version of Access you are using, but I ran into this same problem with 2000. The problem is resolved when you load the Office 2000 Service Release 1/1a (SRT/1/SR-1a).

Hope this helps!

by sl-campbell

I clicked too fast:

2. Try importing the tables and objects into a new empty MDB.

3. When I had this problem before, I could only open then MDB from a copy of the original. Nothing helped (repair or compact). I had to manually search each table for defect records - there were several marked bad records (you'll see them right away). I had to do a copy and paste into a new table on the good records in order to get things working again.

4. Make sure you have the most recent service pack for Access/Jet. If you don't and are trying to open a 97 MDB with a 2000 MDB you will get an error similar.

by red dragoon

I ran a compact and repair from within the ARES 2000 Configuration program, and I was able to get into the database after converting it into Access 2000 format. Thanks!

by wordworker

Here's a tip for future databases: Instead of storing the images in the .mdb, store them in a separate folder, and store links to those images in the .mdb. Makes for a smaller database, though it doesn't guarantee the file won't get corrupted anyway.

by red dragoon

There won't be another time. They're redoing the whole system. Thanks, though, for your suggestion.

This discussion is closed to new replies.