July 29th, 2002, 09:06 PM
Access Data Replication between MDE Files
Hi, quick question. How would I go about replicating data between two different Microsoft Access 97 MDE files? Would I just simply build a query and run it when I want the other database updated? I am trying to maintain information on a development version of the database while the production version is being updated.
July 31st, 2002, 04:30 PM
forgive me...but what are MDE files? are you just trying to replicate the data?
July 31st, 2002, 09:41 PM
MDE files are microsoft access database files.
Yeah I am trying to replicate the data...but the development version of the database has a different table structure, so I can't just simply copy the data over.
August 1st, 2002, 09:09 AM
you could always just use some VBA to grab the data from one table, message it, then put it into the next table. are you familiar with VBA at all?
August 1st, 2002, 10:16 AM
Vaguely, I will look into using VBA for this. Thanks!