To automate a report from encrypted database I used a free uility AutoHotkey.
Here is the source script, that I compiled to mydb.exe and then deleted
-----------------------------------------------------------------------------------------------------------------
run "C:\Program Files\Microsoft Office\OFFICE14\MSACCESS.EXE" c:\projects\mydb.mdb /cmd "auto"
WinWait, Password Required, , 3
sendinput {p}
sendinput {a}
sendinput {s}
sendinput {s}
sendinput {w}
sendinput {r}
sendinput {d}
sendinput {Enter}
return
-----------------------------------------------------------------------------------------------------------------
Then I used mydb.exe to run as a scheduled job.
Thank you for visiting my blog. It is all started with Microsoft Word/Excel document recovery method that I implemented at work. My coworkers were so impressed that they “forced” me to create a webpage and post steps required for that method. Later I realized that not many people are reading this blog and I decided to keep it for myself and post here some code and ideas that I could reuse for the future. If you find my posts useful drop a comment for me.
Monday, November 14, 2011
MS Access 2010 /pwd command line switch is missing
Labels:
MS Access
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment