#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    18
    Rep Power
    0

    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.

    Thanks.
  2. #2
  3. SwollenMember
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    the master control
    Posts
    264
    Rep Power
    14
    forgive me...but what are MDE files? are you just trying to replicate the data?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    18
    Rep Power
    0
    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.
  6. #4
  7. SwollenMember
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    the master control
    Posts
    264
    Rep Power
    14
    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?
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    18
    Rep Power
    0
    Vaguely, I will look into using VBA for this. Thanks!

IMN logo majestic logo threadwatch logo seochat tools logo