Move data from MDE database

  • Thread starter Thread starter gdubois
  • Start date Start date
G

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!
 
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
 
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..
 
Back
Top