ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Issue (https://www.excelbanter.com/excel-programming/399797-issue.html)

Mike H.

Issue
 
I have a password on an access .mdb file. In Excel, if I issue the following
command, I am getting an error:

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & "Data Source=" & DataSource &
"; " & "UserID=admin; Password=MyPW44"

Before I put a password on the file, I left off the entire last of the line
from the Semi-Colon before the word UserID. It worked fine. Now I have a
password. I get this error: Cannot start your application. The workgroup
information file is missing or opened exclusively by another user. Ideas?


All times are GMT +1. The time now is 07:08 AM.

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