odd compact and database password problem

[Richard6699]

Hi,

I have a password protected database that is started by a smaller loading db.
The loader db opens the main db supplies the password and the password is changed to "".
When closed the password is set once more.

I also have very similar code that compacts the main db from the loader db. This compacts the main db ok. However when i turn both files into MDEs and operate them in the runtime environment then after the compact takes place I can't open the main db again.
It seems that the password has not been set.

So when they are mdbs the compact code works fine but when they are MDEs in runtime it fails. The only difference is that I add code to the main MDE to stop it opening in full Access. Yet I'm sure that code does not execute when the compact takes place

What am I missing here? Is there a difference between compacting a db in full Access and runtime?

I'm using Access 2000 developer edition.

Many thanks for any suggestions.
Kind regards
Richard

 

[Orion45]

Are you trying to make changes to your application via code after it is compiled into an .mde? If this is the case changes cannot be make to an .mde at run-time since they only contain the compiled version of the code. This is why .mde files are so much smaller and faster. You also cannot compact a .mde for this very same reason.

 

[Richard6699]

Thanks for the reply. The whole thing works fine even when using MDEs within full Access 2000.
It's very odd. Since I posted we've simplified security and will ask the user to supply the password. The whole thing was too flakey otherwise.