Daily Batch Processing in Access?

[whdyck]

Hi,

I'm using MS Access 2003.

Not sure if I'm in the right forum, but I'd like to know whether it's possible to automate the daily load of a csv file into an Access table from a network folder, and perform other scheduled processing similar to what a stored procedure might do during a daily batch job.

Thanks for any help you can give.

Wayne

 

[pbaldy]

I'd probably create a db that performed your desired process when it opened, then quit. I'd open that db from Windows Scheduled Tasks on the appropriate schedule.

 

[KenHigg]

I have a dedicated machine on the network with an mdb that stays open 24/7. Then there is an endless loop running in some code that checks a table to see if a task is scheduled to run based on the time of day. I can schedule automatic jobs that pull from attached odbc sources like the corp datawarehouse, or check for emails, etc... It's a low tech and has some admin but is pretty reliable. I even send out automated email reports...

 

[whdyck]

I'd probably create a db that performed your desired process when it opened, then quit. I'd open that db from Windows Scheduled Tasks on the appropriate schedule.

Thanks. I wasn't even aware of the Windows Task Scheduler. Looks handy. Now I know.

 

[whdyck]

I have a dedicated machine on the network with an mdb that stays open 24/7. Then there is an endless loop running in some code that checks a table to see if a task is scheduled to run based on the time of day. I can schedule automatic jobs that pull from attached odbc sources like the corp datawarehouse, or check for emails, etc... It's a low tech and has some admin but is pretty reliable. I even send out automated email reports...

Thanks, Ken. This sounds promising. I had no idea Access could do all this stuff.

Can you provide any other details? Is this "endless loop" inside an Access function or macro? When the loop snags a job record that needs to execute, how does that execution happen? I've never used macros before, but I suspect maybe in a macro somehow?

Sorry. These are probably dumb questions.

Thanks for any additional help you can give.

Wayne