ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening Dabase with Password (https://www.excelbanter.com/excel-programming/327145-opening-dabase-password.html)

Reto

Opening Dabase with Password
 
Hello

Could someone help me on the following:

How do I have to open an Access.mdb that has a password,
lets say password is SECRECT


DBEngine.Workspaces(0).OpenDatabase(Access.mdb)

Thank you very much

Regards

Reto

Michael Hopwood

Opening Dabase with Password
 
Something like:

Set db = DBEngine.Workspaces(0).OpenDatabase(Access.mdb,,,M S
Access;PWD=SECRET;)


"Reto" wrote in message
...
Hello

Could someone help me on the following:

How do I have to open an Access.mdb that has a password,
lets say password is SECRECT


DBEngine.Workspaces(0).OpenDatabase(Access.mdb)

Thank you very much

Regards

Reto





All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com