how to transform data from 1 mdb to another automatically?

  • Thread starter Thread starter Jason Shohet
  • Start date Start date
J

Jason Shohet

We have 2 databases that are part of two 3rd party products. Each database
has a user table, which has similar but not exactly named fields. We'd like
it that when a user gets added to the first db's user table, it gets added
to the 2nd db's table.

If there's no automatic way to do this, is there a manual way? xml, xslt
etc?

Thanks
Jason Shohet
 
Create and run an append query, which can link to a table in another
database. Create the query on the table where the record is added to append
to the other table.
 
When you do an append query, does it move the data automatically when the
data is written to the first table? (ie, like a trigger in sql server) or
do you have to 'run' the query on the table in order to append it to the
other table.

And if you run it twice, won't it add the records twice (which is no good)?

Thanks for the help!
 
Access does not do triggers....

You would have to run this query, setting the parameter of the record to
move. Eitehr from a command button that runs the query, or after some event
in the form when adding. not sure which is the best place for you...your
call :-)
 
Back
Top