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
Author
Message
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 249
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.
 
 
UpdateRemote.mdb
 
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.

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