Access 97 mde build error

[KeithPyra]

I have a baffling situation with an access 97 database. When building an mde file, it will sometimes give an error, and sometimes not.

The error is 'Can't open database (blah). It may not be a database that your application recognises, or the file may be corrupt.'

I have been chasing this one every way I know how, including opening a blank db and importing all the objects.

Typically, if I attempt to build the mde 6 times in a row with absolutely no modifications, the failure will occur on, say, the 2nd, 4th and 5th attempts!

Any ideas out there please?

 

[Parax]

I have only two suggestions to try:

1) decompile your database to clean out old code. (Run: "msaccess.exe /decompile&quot

2) get hold of the MS jet compact utility and run a full compact on the database, This can fix errors that an access compact and repair will not detect. (search MS downloads for Jetcu40.exe)

hope this helps.

 

[KeithPyra]

Thanks Parax for the ideas.

I had tried decompiling, but it seemed to me not to work properly on this database, because it gave an error on the first attempt, and then on a second try merely reported that it had converted Access.mda, with no evident improvement or size reduction to my mdb.

I have taken your advice on the MS compact utility, thanks. Unfortunately, that gives the message 'Error compacting database'.

This is turnng into a frustrating one!

 

[KeithPyra]

Sorry! In my previous post, I meant Utility.mda, not Access.mda......