Access 2000 MDE problem

I have an Access 2000 front end that works just peachy. It contains forms, VBA Code and macro's. It also contains linked tables from two other Access 2000 MDB's.

The problem is I can't compile the front end into an MDE. I get a "Can't create MDE file" (or something close to that) error message. Of course, there is no explaination, or suggestion given.

The help screens suggest that if the front end references VBA in the back end then the backend needs to be MDE's as well.

This is not the case however. The two backends contain only tables that are linked in.:confused:

What do I need to check for that is not mentioned in the MS Help pages?

Gary Campbell

an MDE ?

Cause theres the shift lock and if you put it on a workgroup then it makes it a lot more difficult to get into.

Can you relink in code? if so, then delink all the tables that you can and try making the MDE again.

I had no problems creating an MDE file - have you debug>Compile and saved ?

Regards

Vince

The client insists on an MDE.

I read elsewhere that one should check that the code fully compiles when such an error occurs.

I shall try that next.:D