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.
Printed Date: 19 Apr 2021 at 1:48am
Software Version: Web Wiz Forums 12.03 -

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, - find out why here .
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.
Access 97 (28 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -