Jump to content
Sign in to follow this  
Mark Skrodzki

Microsoft Access database run script

Recommended Posts

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.

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





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


CreationTime= 1c4bd38 c517620


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


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