Hello. Access 2003.
When using vbscript to open a database is it possible to avoid the Startup sequence - the equivalent of holding the shift key?
Also, I'm running a procedure in a database which has a password on it. (The password is on the code, not the database). Is it possible to supply the password in code?
Thanks, Andy.
Start up process
-
agibsonsw
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Start up process
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
HansV
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Start up process
API: Bypassing Autoexec contains rather complicated code to bypass the startup options when opening a database. I have no idea whether it works in VBScript.
It might be possible to use SendKeys to supply the password for the VBA project, but the code will be ugly. See [RESOLVED] Unlocking a project with VBA for an example using Excel.
It might be possible to use SendKeys to supply the password for the VBA project, but the code will be ugly. See [RESOLVED] Unlocking a project with VBA for an example using Excel.
Best wishes,
Hans
Hans
-
agibsonsw
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Start up process
Thank you. I think removing the password temporarily would be much the simpler option. Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.