I am using VB 6.0 with an Access database. The program worked fine until I password protected the database. Now I am getting the following error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
The path is correct and I did open the database exclusively to set the password, but then closed it. The following is the connection string I am using. I can get it to work with an ODBC connection, but I don't want to use that.
VB Code:
Set Conn = New Connection Conn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data source=" + App.Path + "\database.mdb;password=pword" 'The following one works 'Conn.ConnectionString = "PROVIDER=MSDASQL;Data Source=Support;password=pword" Conn.open
Please help!




Reply With Quote