[AccessD] Replication and Referential Integrity

That's the first time I've ever heard that statement, and I see no
reason for it to be true. What kind of replication are you talking
about, partial or full?  And is this database a split front and backend
or not?  If it isn't on a drive shared by them, how are they both using
it and why should it be exclusive to one of them?  Are you actually
passing the database back and forth to different locations?

You really need to fill in more information before you can get a good
answer.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
ewaldt at gdls.com
Sent: Thursday, September 07, 2006 12:58 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Replication and Referential Integrity

I've created a database that is used by two companies. For purposes of
security, it cannot be on a network drive shared by the two companies.
More detail isn't really necessary. What it amounts to is that only one
company can use it at a time.

I have had replication suggested to me. I know what it is, of course,
but have only played with it on a very minor and experimental basis.
However, the individual who recommended it to me is more experienced
with it, and he said that it cannot be used with a database that employs
referential integrity. Is he correct? I am sure that he knows more than
I do about replication, but that doesn't mean much.

TIA.


Thomas F. Ewald
FCS Database Manager
General Dynamics Land Systems
(586) 276-1256