Sign in to follow this  
Followers 0
Mark Skrodzki

Microsoft Access database run script

3 posts in this topic

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.

Share this post


Link to post
Share on other sites



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.


AutoIt3, the MACGYVER Pocket Knife for computers.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0