What name format shld I use for the macro to be run using a batch file?

[AshikHusein]

I want to run a macro using a batch file. I would like to know the exact format that shld be used for the macro name to do this. The batch file opens the dtata base by using the following path:

C:\Program Files\Microsoft \Office\Office\MSACCESS.exe\coding.mdb\(What should I type here for the macro to be run?)

The name of the macro is beeper. Thanks.

 

[FoFa]

AUTOEXEC will trigger the macro when the DB is loaded. We have a couple unattended DB's that run to do some parsing, cleanup and run via Macros. Create an AUTOEXEC macro and have control what ever it is you need done.

 

[AshikHusein]

The way my ACCESS project is structured the macro shld not run when the database is opened because the databse will also be opened manually.

The batch file is used to automatically import a certain TEXT file at certain intervals (ie weekly and monthly) and the macro has to be invoked only if the batch file runs and not when the database is opened manually. (The batch file will run using a windows scheduler)

Can a macro in a database be activated using a batch file?? Thanks.

 

[AshikHusein]

I found the format while browsing the internet:

It is as follows:

C:/Program Files/Microsoft Office/Office/MSACCESS.exe (path to database)/cmd "DB"/x (Macro name).