Microsoft Access database run script

[Mark Skrodzki]

Can someone direct me towards the proper command line to use that will open MSAccess and run a database that has macros in it? I am using SciTE as my editor for the script.

[scriptkitty]

if you want to open an access file and run a macro, you can do it easy with a MAM file.

[shortcut Properties]AccessShortcutVersion=1

DatabaseName=file.mdb

ObjectName=fixmacro

ObjectType=Macro

Computer=WEBX

DatabasePath=C:\Documents and Settings\myname\My Documents\myname\limits.mdb

EnableRemote=0

CreationTime= 1c4bd38 c517620

Icon=265

This is a simple text file that is named macro.mam

It will open the access file and run the macro.

Alternately, you could even dynamically create it, run it, and then delete it all with autoit.

[StevenOfPomroyIL]

This idea of using a .MAM is great. Do you have any more information on how to design a MAM or at least a more comprehensive list of the parameters available for customization? I certainly could not find any useful documentation on Microsoft's MSDN: http://social.msdn.microsoft.com/Search/en-us?query=.mam&x=0&y=0

Thanks