Connecting To Password Connected Database

[sbensen]

We now have all of our scripts working correctly, however, one question remains. We need to have our subject database password protected. How do we format the database query module to run a query on a Access 2000, password protected Database.

There was an example using an Excel file in the help where you write the file location, ; PWD and the file password. Is this the same for access or is there another format. Thanks, Steve

[SupportTeam]

In the "Connect String" entry specify:

 

;pwd=mypassword

 

replacing mypassword with your actual password.