dbTalk Databases Forums  

automatic database updating

comp.database.ms-access comp.database.ms-access


Discuss automatic database updating in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Skynet
 
Posts: n/a

Default automatic database updating - 01-28-2004 , 10:30 AM






Hi,
I want to update some fields in my database automaticly for every hour but I
have no idee how to do it.
Maybe with a script? The programme must keep running as long as my computer
is on. Can somebody help me or know where to find information?
Thx

Tim



Reply With Quote
  #2  
Old   
Ken Wills
 
Posts: n/a

Default Re: automatic database updating - 01-31-2004 , 04:57 PM






I'm doing it now on a weekly basis starting monday (hope it works)...
..
I use windows scheduler to run an empty MS-Database that does nothing but
use this VBA
command at start up time, then of course closes...

(it uses an import spec already prepared)

DoCmd.TransferText acImportFixed, ".\FPHistData.mdb.FlatFileHistory
Import Specification", ".\tblFPHistory",
"N:\PUBLIC\FPHist\DOWNLOAD\TEMP.TXT"




"Skynet" <tim1 (AT) skynet (DOT) be> wrote

Quote:
Hi,
I want to update some fields in my database automaticly for every hour but
I
have no idee how to do it.
Maybe with a script? The programme must keep running as long as my
computer
is on. Can somebody help me or know where to find information?
Thx

Tim





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.