The client is written in vb.net.
The database is Access 2007 with an adp extension. I am trying to connect from vb.net directly to the access database with a adp file extension.
when the user opens the access database directly, he/she is required to enter a Logon name and password.
My vb.net code connection string looks like this:
msAccessConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & txtFileIn.Text & ";Persist Security Info=True; Jet OLEDBatabase User Id=xxxxxx; Password=yyyyy;"
Dim conec As New OleDbConnection(msAccessConnectionString)
Error: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.