Automatic import between two Access 2K3 DBs

[Guest]

I am creating Access DB for my church. There will be two seperate
hierarchical databases that mirror church administration. DB1 will focus on
the local parish while the DB2 will be for the diocese.

Question
I want to know how to setup automatic import to DB2 from DB2 of some tables.

Your insight will be highly appreciated! Thanks

 

[Guest]

Hi.

There will be two seperate
hierarchical databases that mirror church administration. DB1 will focus on
the local parish while the DB2 will be for the diocese.

Question
I want to know how to setup automatic import to DB2 from DB1 of some tables.

Use the TransferDatabase method for each table. For example:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\Work\DB1.mdb", acTable, "tblMyTable", _
"tblMyTable_Parish"


HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.