Run a macro without opening the database

[MDGarcia]

Good day,

I created an mdb whose data will be updated every 10 days. I created a macro to read from a text flat file I receive and to upload the new data into the table.

I want to somehow automate this process to run the macro when its time without opening the database.

I read that I can create a desktop shortcut or use the Scheduler to run either of these commands:

...\path to ms access\msaccess.exe /mymdb.mdb mymacro
Or
...\path to ms access\msaccess.exe\mymdb.mdb /mymacro

I can also try VB coding, but I’m not sure how.

Anyone got ideas on how to achieve this?

Thank you.

 

[PHV]

The syntax is:
"\path\to\msaccess.exe" "\path\to\database.mdb" /x macroname

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mp9]

Also check out the Handy Access Launcher (HAL) as a way of automating and scheduling macro runs for a db, as well as other admin tasks like compacts and repairs.

HAL is shareware from

http://www22.brinkster.com/accessory/resources/001.shtml