Thread: Issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default 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?