0kb

[Ehab Awwad]

I tried to compact and repair my access data base
but after that i have the folloing message unrecognized
database
AAND THE DATA BASE SIZE BECOME 0KB
THE ERROR code IS 800A03EA
is there any way to recover my data
regards

 

[Brendan Reynolds]

When you compact using the same name for the source and target MDB, Access
creates a temporary file, compacts to that temporary file, then deletes the
original file and renames the temporary file with the same name as the
original file. If no file with the name 'db1.mdb' exists in the folder,
Access will use that name for the temporary file. If a file with that name
already exists in the folder, Access will use the name 'db2.mdb'. If a file
with that name already exists, Access will use the name 'db3.mdb', and so
on.

Chances are good, therefore, that your data may still exist in a file with
such a name.

If not, check the recycle bin.

I both of the above fail, then I'm afraid that as far as I know the only
remaining options are to restore your most recent backup or call in a data
recovery expert.