HELP ! Compaction error ( reserved error -1038 )

[RichardatManAlive]

In my Access 200 database I have just got an error : Reserved error( -1038) , locks me out of my database.
According to Microsoft Knowledge Base Article - 247489 this comes about if you compact a database in Access 97 then run it in Access 2000.

Not quite my situation, I have my database split between backend and frontend, I compacted the back end database separately to the front end ( both are in Access 2000 ) .

Anyone have any ideas how I can recover from this ?

Richard Aston

 

[humbleprogrammer]

What's the full error message?

 

[RichardatManAlive]

The full error message was ;

Reserved error (-1038)

Thats it!

Richard

 

[humbleprogrammer]

Try importing all your database objects into a new database.

- Open a new Access database.
- Go to File - Get External Data - Import.
- Choose the database that's giving you trouble.
- This should display all objects. Click 'Select All' under all of the tabs.
- Click OK.
- Compact/Repair the new database.

This should hopefully create a new database for you that's not corrupt.

 

[RichardatManAlive]

Thanks for the tip, it worked, I also had to run the linked tables manager .

Whew! a small disaster avoided

I won't be compacting my backend separately again .

Richard

 

[humbleprogrammer]

Good News!