Elam, Debbie
DElam at jenkens.com
Fri Sep 8 08:38:40 CDT 2006
I have used replication on databases with referential integrity, so that is not an issue. Be sure to keep the master in a safe location where the users cannot touch it and where it is backed up frequently. You should not get corruption, but it does happen more often with replication. Keeping that master at a remove form the day to day work helps recovery go smoother. Debbie ----- Original Message ---- From: ewaldt at gdls.com To: accessd at databaseadvisors.com Sent: Thursday, September 7, 2006 3:57:39 PM 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 This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.