A
Arch Stanton
I hate to ask such a boneheaded question, but the internet just doesn't
seem to be able to help me.
I'm running Access 2003 on MS Vista. I'm trying to write some VBA code
in a module, but I keep getting Error 3706 ("Provider cannot be found.
It may not be properly installed"). I've triple-checked my connection
string, but it's fine. I tried to install the updates I found on the
Microsoft page, but I get the message that if I'm running Vista then I
already have the most current Jet 4.0 version.
I don't think this is the problem, but for the record, here's the code
I'm using to connect to my database:
Dim objConnect As ADODB.Connection
Dim objCommand As ADODB.Command
Dim rstWaterQuality As ADODB.Recordset
Set objConnect = New ADODB.Connection
objConnect.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.00;Data
Source=W:\CurrentSWIS.mdb;"
objConnect.Open
I'
seem to be able to help me.
I'm running Access 2003 on MS Vista. I'm trying to write some VBA code
in a module, but I keep getting Error 3706 ("Provider cannot be found.
It may not be properly installed"). I've triple-checked my connection
string, but it's fine. I tried to install the updates I found on the
Microsoft page, but I get the message that if I'm running Vista then I
already have the most current Jet 4.0 version.
I don't think this is the problem, but for the record, here's the code
I'm using to connect to my database:
Dim objConnect As ADODB.Connection
Dim objCommand As ADODB.Command
Dim rstWaterQuality As ADODB.Recordset
Set objConnect = New ADODB.Connection
objConnect.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.00;Data
Source=W:\CurrentSWIS.mdb;"
objConnect.Open
I'