MDE Question

[aw23]

I have a split database where the BE is on the network and the FE is on every users computer. Both files are currently mdb. My question is if I make the FE an mde, will it improve performance? I have searched in this forum and have not found anything.

Thanks

 

[JerryKlmns]

Nice thought but, if you try to save as an MDE file a Microsoft Access database (.mdb) or an add-in (.mda) that references another Access database (i.e. linked tables) or add-in, Microsoft Access displays an error message, and doesn't let you complete the operation. To save an Access database that references another Access database as an MDE file, you must save all databases in the chain of references as MDE files, starting from the first database referenced. After saving the first database as an MDE file, you must then update the reference in the next database to point to the new MDE file before saving it as an MDE file, and so on.

For example, if Database1.mdb references Database2.mdb, which references Database3.mda, you would proceed as follows:

Save Database3.mda as Database3.mde.
Open Database 2.mdb and change its reference to point to the new Database3.mde.
Save Database2.mdb as Database2.mde.
Open Database1.mdb and change its reference to point to the new Database2.mde.
Save Database1.mdb as Database1.mde.

If you proceed with this .mde, just remember to keep a copy of your .mdb files somewhere safe because there is no undo of .mde to get .mdb