mde files

T

Tammy Boehme

My problem is that a development program for access 97 has a .mdb extension
but seems to be acting like a .mbe file. Basically, I cannot design any of
the forms in the database anymore. Is there a setting that can be taken off
or a way to save the database restoring the ability to design in the forms
tab again? Any help is very much appreciated.
 
A

Allen Browne

Sorry, Tammy. That's not possible.

It is not just a matter of the last character of the file extension. The
actual text of the code is absent from an MDE, so there is no way to
recreate it out of thin air.

It is possible to create a new (blank) database, and import the tables and
queries. If you have an older copy of the database that does have the fully
editable forms in, you can then import the forms, reports, and modules from
that database, so you now have the older form and the current data.

There is a utility out there somewhere to import the forms without the code.
But all the event procedures, functions, subs, etc must be re-written from
scratch unless you have an MDB containing the forms, reports, and code.
 
Top