I'm using a ADODB record set in oder to open a password protected database. Now that the database is open, I need to run a macro. I can't seem to find how to do that. Is it even possible from a ADODB connection?
I'm using a ADODB record set in oder to open a password protected database. Now that the database is open, I need to run a macro. I can't seem to find how to do that. Is it even possible from a ADODB connection?
ADO has nothing to do with opening Access which is what you need to do in order to run a macro. you'll need to automate the access application
for instancePlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Not that I'm aware of, you would have to automate Access with Excel and create an instance of it. This does of course mean that all users of the excel workbook would need access installed.
The database is password protected. How can open it using your sample code?
Please Login or Register to view this content.
Thanks! I'll give it a try.
That worked perfectly! Thank you so much for your help.
you're welcome :-)
If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.
New quick method:Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks