Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - UpdateRemote.mdb ( advanced )
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

UpdateRemote.mdb ( advanced )

 Post Reply Post Reply
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 20 Feb 2008
Status: Offline
Points: 261
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: UpdateRemote.mdb ( advanced )
    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):
Access 2000 DAO (144 KB): uploads/5/
Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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