VBScript - Open a Access DB with both mdw and database password (1 Viewer)

FrostByte

Registered User.
Local time
Today, 21:37
Joined
Jan 15, 2015
Messages
56
Hi,

I'm looking for a VBScript I can run with the windows scheduler that will...

Open a Access DB with an mdw file
AND... which has a database password

So far I have...
"C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "C:\Dir\DATABASE.mdb" /wrkgrp "C:\Dir\MDWFILE.mdw" /user "UserName" /pwd "QWERTY"


Which will work but does not take into account the database password.
 

isladogs

MVP / VIP
Local time
Today, 21:37
Joined
Jan 14, 2017
Messages
18,186
Have you tried using a string variable in place of the password?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:37
Joined
Oct 29, 2018
Messages
21,358
Hi. The only way I know how to open a password-protected database is through automation, so I think that leaves out the MDW part, unfortunately.
 

Users who are viewing this thread

Top Bottom