MDE File

[Millie]

I have saved a form in an MDE file format, and is being used with data being
added. I have the original form saved in an MDB format. I now have to change
the design of the form Which I am able to do. My problem is putting the new
design on the MDE file which has all the data on it. If I try to resave it I
lose the data Help what I I doing wrong

 

[Ed]

1st of all, you should put all of your tables in one database (the back-end)
and then put all of the queries, forms, reports, macros in another database
(the front-end). Link the back-end tables to the front-end database. You can
then change your forms, etc. as you need without impacting the data itself.

You can accomplish this now by 1st creating a new, empty, front-end
database. Link the tables and Import everything else. This becomes your
front-end MDB file.