how to transform data from 1 mdb to another automatically?

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
 
K

Kevin3NF

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.
 
J

Jason Shohet

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!
 
K

Kevin3NF

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access to Access Automatic Updates 6
Using Access and SSIS to get data out of Sharepoint 1
import single record set from one Access BD to second DB 3
getting data from a shopping cart mysql database 0
Transfer data from one Access DB to another 3
Transfer data from 1 Access DB to another without using Linked tab 3
Importing Tables and Appending Data From Temporary db 1
Populate a table in one database from a table in another database 6

Top