Move data from MDE database

[gdubois]

Good morning!

I just found out that I cannot edit a Access MDE database (great!!).
I found the MDB file, so I will be able to do all the changes I
require.

However, a lot of data has been entered in the MDE database for the
past few year.

How can I transfer all this data to the MDB file, so I can make the
changes with the right data?

I am using Microsoft Office Access 2003.

Many thanks!

 

[Guest]

Your database isn't split (back-end and front-end)?

Have you tried from your mdb to import the tables/data... from your mde?

Daniel

 

[Joan Wild]

Backup your MDB. Open it, and delete all the tables. Then File, Get
External Data, Import...locate the MDE and import the tables.

Now you have the current tables in the MDB. I strongly suggest you now
split the MDB - the backend would contain just the tables/relationships.
The frontend MDB would contain all the other objects, along with links to
the backend MDB.

There is a wizard you can use to split it - Tools, Database Utilities..