Roger's Download Samples - KeepingDatabasesInSync.mdb (Access 97 only)

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: 16 Apr 2024 at 3:45pm
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 .<