I have created and access database and has entered it into an ODBC.
In my database I have a macro that runs as autoexec so whenever it starts it just initiates that macro and afterwards quit the application.
The reason I created an ODBC is a thought of mine I had. I would like my collegues to get access to the database to retrieve info from it. So I was wondering if there was a possibility to create a bat-file or short-cut, that I can distribute to my collegues, when clicked, connects to the ODBC and run the macro?
Looking at my question I think I'm far out, but I ask anyway since it sometimes surprise me what is possible
In advance tx for whatever amswer this may give me ;-)
In my database I have a macro that runs as autoexec so whenever it starts it just initiates that macro and afterwards quit the application.
The reason I created an ODBC is a thought of mine I had. I would like my collegues to get access to the database to retrieve info from it. So I was wondering if there was a possibility to create a bat-file or short-cut, that I can distribute to my collegues, when clicked, connects to the ODBC and run the macro?
Looking at my question I think I'm far out, but I ask anyway since it sometimes surprise me what is possible
In advance tx for whatever amswer this may give me ;-)