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
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.


AutoIt3, the MACGYVER Pocket Knife for computers.

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  

×