Automatic database import between Access 2003 dbs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sokan33 - 26 Aug 2005 20:15 GMT

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 setup automatic import to DB2 from DB2 of some tables.

Your insight will be highly appreciated! Thanks

Reply to this Message

Sokan33 - 26 Aug 2005 20:48 GMT

I meant to say setup automatic import to DB2 from DB1 of some tables.
Thank you folks.

> I am creating Access DB for my church. There will be two seperate
> hierarchical databases that mirror church administration. DB1 will focus on
[quoted text clipped - 4 lines]
>
> Your insight will be highly appreciated! Thanks

Reply to this Message

Douglas J. Steele - 26 Aug 2005 22:13 GMT

Why duplicate the data? Why not simply link from one database to the other,
so that both will always use the same data?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am creating Access DB for my church. There will be two seperate
> hierarchical databases that mirror church administration. DB1 will focus
[quoted text clipped - 5 lines]
>
> Your insight will be highly appreciated! Thanks

Reply to this Message