Unable to create MDE

[Jeff Pietsch]

I appreciate any help anyone can give.

I am trying to convert my front-end database to an MDE
and I get the error message "Microsoft Access was unable
to create an MDE database."

I have successfully converted the back-end to an MDE.

I then reset the links in the front-end to point to the
back-end MDE instead of the back-end MDB.

I have checked that all of the forms and queries work.
I have compiled the VBA modules with no errors.

This is not a replicated database.

User-Level Security is the only other thing I can find in
the books that might be the problem but I do not know how
to check this.

Thank you in advance for any help.

 

[Jeff Pietsch]

I finally discovered that my VBA code was referencing
the "Microsoft ActiveX Data Objects 2.1 Library" insterad
of the 2.5 version.

Once I changed it to 2.5 then the MDE file built with no
problems.

Thanks.

JP

 

[Van T. Dinh]

BTW, we don't normally convert the Back-End to MDE format since Back-End
only contains Tables, i.e. no VBA code to be converted.