Print Page | Close Window

UpdateRemote.mdb ( advanced )

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: 24 May 2020 at 6:36pm
Software Version: Web Wiz Forums 12.03 -

Topic: UpdateRemote.mdb ( advanced )
Posted By: Roger Carlson
Subject: UpdateRemote.mdb ( advanced )
Date Posted: 15 Jul 2008 at 11:27pm
Please consider donating $1 per sample downloaded, - find out why here .
This sample illustrates how to run an update to a Back End (BE) database remotely for performance reasons. Many times you don't want to run them from the Front End application because of the amount of network traffic.

This sample uses a "sniffer" program (UpdateRemote) to poll for the existence of a text file. When the text file appears, the sniffer launches a macro on the BE database (UpdateRemoteBE) which runs the update. Since all of this happens on the server, network traffic is not an issue.

When this form opens, it begins to check for the existence of the text file "shoeimport.txt". Pushing the Export Table to Text File will create this file. (In the real world, this file will most likely be created by another program, say a mainframe process.) After 1 minute of the file being created, it launches the macro "Macro1" in the BE database. This macro starts the update, deletes the text file and closes the BE database.

In order to run, this form "Main" must be open. It checks for the file every minute (60000 timer intervals). The code for this in the OnTimer event of this form and the interval is set in the TimerInterval property.

Access 97 (73 KB): - uploads/5/
Access 2000 DAO (144 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. -