I have tried a number of methods for connecting an Access XP database
without success and I need some help.
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= C:\DB.mdb; User
ID=Admin; Password=***"
ERROR
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup
information file is missing or opened exclusively by another user.
The database uses a workgroup file so I tried the following.
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= C:\DB.mdb;" & _
"Jet OLEDB:System Database=C:\SYSTEM.MDW;" & _
"User ID=Admin; Password=***;"
ERROR
Microsoft JET Database Engine (0x80004005)
Microsoft Jet database engine cannot open the file ''.
is already opened exclusively by another user, or you need permission
to view its data.
I have looked at a number of different resources and have yet to find a
solution that works.
Nolan