Print Page | Close Window

KeepingDatabasesInSync.mdb (Access 97 only)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=336
Printed Date: 25 May 2020 at 5:19am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: KeepingDatabasesInSync.mdb (Access 97 only)
Posted By: Roger Carlson
Subject: KeepingDatabasesInSync.mdb (Access 97 only)
Date Posted: 01 Aug 2008 at 2:53am
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 
KeepingDatabasesInSync.mdb
 
The question is: When you copy an Access front-end database to individual workstation, how can you programmatically keep them in sync. The answer requires a master network copy of the front-end that the administrator can change and have the client copies be automatically notified that a change has been made.

This application illustrates how this is done. Copy this to a directory, open the database and re-link the tables. Then copy the file. Make a change to a form in the ORIGINAL file and then open the NEW COPY. See the Explanation button on the Switchboard form for more information.
 
Download
Access 97 (28 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/KeepingDatabasesInSync97.zip - uploads/5/KeepingDatabasesInSync97.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net