MDE and extracting data

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,

ive created a database and want to compile it, so i
created an MDE file. In the meantime ive been upgrading
certain parts of the original file that created the MDE;
enhanced queries and upgraded forms ect...

the MDE file has been used successfully, but more data has
been added to the tables in the MDE file. what i need to
do now is reissue the database with the enhancements but
first need to suck the data out of the old MDE file...

ive tried to import it but it doesnt seem to work, am i
missing something, (ps. im using access 97)
..
 
Paul,

Ideally, you split your database in a Front End (everything but the data
tables and Back End (data tables only), and give each user their own copy of
the front end, all connected to the same, common back end residing on a
server. That scheme not only helps minimize corruptions in a multi-user
environment, but also allows you to make changes to the front end (like the
ones you made) and distribute the new version of it to users, while all the
data is intact in the back end.

Don't worry, though, it's not too late yet! Start by creating a new, blank
..mdb, and import all the tables from the working copy of the .mde (so you
get all the latest data). Then import all the other objects (queries, forms,
reports, macros, modules) from the copy where you made your recent design
changes, so you get the latest version of those as well. Now you have an
..mdb with the latest design and up-to-date data. This is a very good time to
split to a FE/BE scheme (Tools > Database Utilities > Database splitter...
piece of cake!). Following the split, make an .mde from the FE .mdb, and
you're done! Just make sure you keep a safe copy of the FE .mdb for further
development if needed.

HTH,
Nikos
 
Back
Top