I have a program that accesses an Access2000 database. Using ADO (VB6) it works fine with connection string - open recordset, I then load a popup menu from that recordset - no problems. One part of the program uses a data control [ADO Data Control 6 (SP4)(OLEDB)] which is the DataSource for a DBGrid - all works fine on Win9x, ME, XP and some Win2000 machines, however there is one (remote) site hoping to use the program that is getting the following message...
"Runtime error 3170 Couldn't find installable ISAM"
... on a couple of Win2000 machines.
The error is generated by the line of code:-
Prior to this I set:-
, and
The Connect Property is set to Access2000;
I did a search on ISAM and as a result got them to install MDAC2.7, the latest JET 4.0 Service pack and run regsvr32 on Msrd3x40.dll... all to no avail.
As you might imagine, chronic frustration is beginning to set in and I am developing a very strong dislike for anyone whose first name is "Bill".
Any suggestions leading to the eventual solution will be wonderfully appreciated.
Doug.
"Runtime error 3170 Couldn't find installable ISAM"
... on a couple of Win2000 machines.
The error is generated by the line of code:-
Code:
dcGetData.RefreshPrior to this I set:-
Code:
dcGetData.DatabaseName = strDataPath
Code:
dcGetData.RecordSource = strSQLSearchThe Connect Property is set to Access2000;
I did a search on ISAM and as a result got them to install MDAC2.7, the latest JET 4.0 Service pack and run regsvr32 on Msrd3x40.dll... all to no avail.
As you might imagine, chronic frustration is beginning to set in and I am developing a very strong dislike for anyone whose first name is "Bill".
Any suggestions leading to the eventual solution will be wonderfully appreciated.
Doug.
