Click to See Complete Forum and Search --> : Automatic start of msaccess db


margo1
12-07-2005, 10:24 AM
I've built ms access db with queries and macros. I need to create a script that would automatically start up my msaccess db from a desktop and execute queries and macros within my msaccess db. Can anyone help me? I'm not familiar with VBA.

soccermatrix
12-07-2005, 10:48 AM
I think one way of doing this is to use the wizard and create a formatted table to input values. Then all you have to do is save a shortcut on your desktop. Look into the MS Access wizards, they will give you a hand on this.

chrismartz
12-12-2005, 10:12 PM
I have never used this with ms access, but in SQL you can load procedures such as this through your connection. It would be (EXEC procedure_name) in place of your normal SQL query.