Jet.OLEDB

I

Ian Bayly

Hi

I have a VB6 application which runs fine on my development PC but and fails
on my Test PC at the point I create an ADO recordset.
The error is arises on line 40 below with message "Error number 91: Object
variable or with block variable not set"
I suspect the problem is with the ADO connect string
"Microsoft.Jet.OLEDB.4.0".
How do I ascertain what the difference is between the jet versions on the
two PC's.
Both are Office 2003 and XPPro (although different SPacks).
Can I just un-register and re-register the msjet40.dll or is that far too
simplistic?

TIA

Ian B

Snip

Dim sConn As String
sConn = "Microsoft.Jet.OLEDB.4.0;Data Source =
C:\DPQAS\Items\DPQASDatabase.mdb;"
10 On Error GoTo GetRecordset_Error
20 GetRecordset = False
30 myConn.CursorLocation = adUseClient
40 myConn.Open sConn '"Microsoft.Jet.OLEDB.4.0;Data Source =
C:\DPRO\QAS\HowardsItems\QASDatabase.mdb;"
50 Set myRs = New ADODB.Recordset
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I read an Excel database in C# 0
Create external database 0
ADO connection to Excel 2007 *.xlsx files? 8
Adding table into existing access database via ADO 0
problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0 3
testing for password in ADODB connection. 0
ADO connection query fail when using UNC in FROM clause 2
pivot table connection access 1

Top