I have three access 2007 databases one houses the data and a second houses all the forms, code, etc for a custom app and using linked tables to connect to data in the first database.
Enter database #3, this guy is also going to connect to the tables in db 1 via linked tables and the reason for this guys existence is to manage an automated import/export process between my custom app and a external commercial app.
The commercial app is programmed to accept csv files in an import wizard that is done manually, all I can do with access is create the *.csv file as a table export and then create a system call to copy the file to the right spot on the network for the custom app to find it.
The commercial app is also programmed to dump csv files out in an autmated fashion.
so this third db will run a system call to check for new exported files, and if there are any, process them and update my database.
my problem is not with the code for the import or export process by problem is triggering the procedures on a time basis.
I *think* I need a loop that sleeps X minutes wakes up, checks to see if there is anything to do, does it if needed, and goes back to sleep for X more minutes and starts again. Yea, this is an infinte loop.
I need help with the time based triggers and getting them done is such a way as to not consume all the cpu resources checking time during the *sleep* cycle.
Im open to suggestions on other ways to do this. so a time based loop is not strictly required.
Thanks all for the help and insight
Start Free Trial
