Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cannot read Access2000
- Thread starter AS400
- Start date
Your question is a little vague.<br>
Were you using ADO to open a connection to the Jet Database?<br>
What version of ADO? 1.5/2.0/2.1/2.5? ADO 2.1 is the best.<br>
2.5 is for Windows 2000. Wouldn't use that in a production system just yet.<br>
What version of the Jet driver? 3.x or 4? Use 4.<br>
If this isn't close to a solution to your problem please reply with full description of your problem and the solutions you have tried to date.<br>
<br>
Regards<br>
<br>
Were you using ADO to open a connection to the Jet Database?<br>
What version of ADO? 1.5/2.0/2.1/2.5? ADO 2.1 is the best.<br>
2.5 is for Windows 2000. Wouldn't use that in a production system just yet.<br>
What version of the Jet driver? 3.x or 4? Use 4.<br>
If this isn't close to a solution to your problem please reply with full description of your problem and the solutions you have tried to date.<br>
<br>
Regards<br>
<br>
- Thread starter
- #3
Sorry for my question as you said is little vague, but Iam suppries that you can handle and I have already tried for what u sugest and successfully. My previous question are why visual basic 6 cannot read Microsoft Access 2000 with data control.<br>
Aniway thankyou for your reply<br>
<br>
Regard<br>
<br>
HBL<br>
Aniway thankyou for your reply<br>
<br>
Regard<br>
<br>
HBL<br>
The Data control in VB is not compatible with Access 2000 directly.<br>
<br>
First create your DAO recordset and then assign it to the data control.<br>
set db = opendatabase(access2000 mdb)<br>
set rs = db.openrecordset("select * from table"
<br>
<br>
set data1.recordset = rs<br>
<br>
now the Data control has the Access2000 recordset.<br>
<br>
also see Microsoft's article on the subject<br>
Q238401 - PRB: Getting Unrecognized Database Format Error Message When Upgrading to Access 2000 <br>
<br>
<br>
Hope this helps<br>
Jon
<br>
First create your DAO recordset and then assign it to the data control.<br>
set db = opendatabase(access2000 mdb)<br>
set rs = db.openrecordset("select * from table"
<br><br>
set data1.recordset = rs<br>
<br>
now the Data control has the Access2000 recordset.<br>
<br>
also see Microsoft's article on the subject<br>
Q238401 - PRB: Getting Unrecognized Database Format Error Message When Upgrading to Access 2000 <br>
<br>
<br>
Hope this helps<br>
Jon
- Status
