UpdateRemote.mdb ( advanced ) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
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 |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |