I am using the following code to connect to MSAccess97...
Dim cnWGPProjMgr As ADODB.Connection
Set cnWGPProjMgr = New ADODB.Connection
.Provider = "Microsoft.Jet.OLEDB.3.51"
.ConnectionString = PMdB
I now have to use Windows2000 with mdac 2.6 and I get an error saying the
provider can not be found. What is the best way to connect to an MSAccess97
database with mdac 2.6? I am trying to minimize the code I have to use.
Thanks for the help.