DBs that are absolutely crashed, but why?

[wolfykaos]

Hello:

I'm a programmer and I'm working as a programmer of a commercial application made in VB that uses MS Access. Recently some clients are refering to us because their DBs stop going on. We tell them to send it to us, and when we open the DBs it appears the following error (I'm spanish and the error is in my languaje too, so I'll try to translate it the best I can):

"This DB is in an unexpected state. MS Access can't copy it.

This DB has been converted from an Access older version DB using the DAO CompactDatabase method insted of using the command Convert DB from the Tools menu (DB Utils submenu). The DB has stayed in a parcial conversion state.

If you have a copy of the DB in its original format, use the Convert DB command from the Tools menu (DB Utils submenu) to convert it. If you don't hace the original DB, make a new empty DB and import the tables and querys to avoid data loss. The other objects cannot be recovered"

This is all, but we don't know how it's happening (there are many clients that don't hace any trouble). If we try to import the tables, it told the same error. It doesn't work compacting nor repairing. We're desperated because the clients are losing data. Do you have any clue about this?

Thanks a lot in advice

 

[JeremyNYC]

Two things:
1) A professional data recovery service will most likely be able to recover every ounce of data in every one of those mdbs. Peter Miller's PKSolutions is one such outfit, and they're highly respected (I've never used them and I have no affilitation).

2) There are a bunch of posts with that error here and at comp.databases.ms-access. I assume there's something in MS's knowledge base. Do searches here, on groups.google.com, and at MS and you may well find both cause and solution.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.