MDE database shift bypass disabled

[ziccardi]

hi we have an mde database that was written by an ex-employee. Some update our company made is requiring us to re-link all our database tables, however, I'm assuming that the shift bypass key was disabled because when I hold down the shift key the database does not display the tables/queries etc. I'm wondering if there is a way to enable this functionality so we can update our table links.
Thank you for your assistance.

[colintis]

mde database is a locked version of the original .mdb database. Find that original .mdb database, do all the necessary upgrades to .accdb or whatever Access version you're using, including update link tables. Then go to [Database Tool] make mde/accdb in the toolbar/ribbon.

[ziccardi]

If I follow these directions, what will happen to the tables that are in the mde.

[colintis]

Normally we would split the database into front-end and back-end. Where all tables are stored in the back-end (remains in .mdb), and the rest of the thing are in front-end (.mde). It is much more secure to prevent database crashes or data lost.

[NeoPa]

Ziccardi:
Some update our company made is requiring us to re-link all our database tables

From your earlier comment I would guess that your setup is already FE/BE, and therefore the data is already stored away from the FE that you're updating (reproducing). It's always good practice though, to keep backups of everything until you are sure that you will never again need it. If you find you are missing anything vital after the new database has been put in place, then simply revert to your backup copy.