Very Computer

I am using the following code to connect to MSAccess97...

Dim cnWGPProjMgr As ADODB.Connection
Set cnWGPProjMgr = New ADODB.Connection
With cnWGPProjMgr
    .Provider = "Microsoft.Jet.OLEDB.3.51"
    .ConnectionString = PMdB
    .Open
End With

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.

You should use "Microsoft.Jet.OLEDB.4.0" for provider...

I am using the following code to connect to MSAccess97...

Dim cnWGPProjMgr As ADODB.Connection
Set cnWGPProjMgr = New ADODB.Connection
With cnWGPProjMgr
    .Provider = "Microsoft.Jet.OLEDB.3.51"
    .ConnectionString = PMdB
    .Open
End With

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.

 Jet 4.0 Service Pack 3 is available if you are installing MDAC 2.6 and also need
to install the Jet components.
http://www.microsoft.com/data/download_Jet4SP3.htm

Quote:-----Original Message-----

I am using the following code to connect to MSAccess97...

Dim cnWGPProjMgr As ADODB.Connection
Set cnWGPProjMgr = New ADODB.Connection
With cnWGPProjMgr
    .Provider = "Microsoft.Jet.OLEDB.3.51"
    .ConnectionString = PMdB
    .Open
End With

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.
.

Would you have to do this for MDAC2.1 to MDAC2.5. We upograded and have had
nothing but trouble with performance on some computers since. Seems to be a
theme on some of the messages here. We cannot fathom out why, although AMD
processors seem more vulnerable.
Peter Richards