Issue

M

Mike H.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top