Creating a MDE File

[Denise]

I have a database that I made into an MDE file and put a
shortcut to the MDE file on everyone's desktop. Now when
they add a record everything is fine in the MDE database.
But when I go back to change a form, query, VBA, etc. and
make that into the MDE file all added records are missing
in the new MDE database. What am I doing wrong?

Thanks,

Denise

 

[Cheryl Fischer]

It sounds as if you have given your users a single database where the tables
are stored in the same file as the queries, forms, etc.

You need to split your database into a front-end (containing all queries,
forms, reports, macros and modules) which can be delivered to your users as
an MDE and a back-end (containing all shared tables). The front-end will
contain links to the tables in the back-end.

When you need to modify the front-end, you can do so and deploy it to users
without impacting or overwriting the data in the back-end tables.