Why Unrecognised database format Error?

[FuzMic]

Hi gurus

There is one phenomenon that is really puzzling. Periodically when I open a particular form after coming from another specific form, I encounter this error message

Error code 3343: Unrecognized database format BEnd.mdh.

After this error, the msaccessFE .mde had to be restarted. Again it is happening intermittently.

As far as I can see, there is nothing wrong with BackEnd.mdb. I check the VB6 codes to see if there anything odd but to no avail. This all is happening in Access.03 in winxp.sp3.

:banghead:

 

[sneuberg]

How's the connection between the frontend and backend? If it's a WIFI connection this wouldn't surprise me.

 

[The_Doc_Man]

Usually when I see this, something has happened to a database that leaves it in an unknown or indeterminate state due to a network drop during a transaction. I'm going out on a limb here, but I think it sets itself up to do something, does part of it, fails, and can't undo itself without manual intervention. At that point, whatever it set up points at least partly to an area that didn't get written because of the network drop. I can fix this most of the time by doing a compact and repair on the database file that got wonked up.

 

[FuzMic]

Thanks guys

There is no wifi at all, the BE is actually another folder within the same computer, so the questions of connection dropping should not be there.

I will go along with idea that when the FE try to approach the BE, something in the codes may have cause it fail to process it.

I have since then being playing with the codes to see if there is something odd, i think it is something to do with tinkering the target.table that is about to be opened by the form, if you know what i mean.

Thus I have tried the following that seem to solve the problem

1. Whenever a target.table is updated or deleted, i let the mdb to sleep 1000 to digest before the form process the the same table.
2. I also move the the tinkering of the target.table outside the open.event of the form, thus again giving .mdb some breathing time.

I don't know if all these make senses but I seem to resolve this intermittent behaviour.

 

[FuzMic]

Hi guys

I think i finally found the cause.
It only happen when i try to rename a table, then followed by compacting the renamed.

Name "Tocompact.mdb" As "Temp,mdb"
DBEngine.CompactDatabase "Temp.mdb", "Compacted.mdb"

It only happen in one particular PC.xpwin.sp3. After renameing mdb, i think msaccess.02 did not recognise Temp.mdb as valid mdb. I think it is a filesystem hitch. It never happen in other pc with xpwin.sp3. In a way i can avoid using this pc until i reinstall the OS or ....

Appreciate any comments.