Unrecognized data base format (Access 2000) 1

[catfish]

I am susing VB6. When I create a database with Access 2000 and use it with VB6, bound, setting the RecordSource, I receive an error: Unrecognized data base format! It is ok under Access 97. Now What? Any suggestions?

 

[Catrina]

Go to <A HREF="

http://msdn.microsoft.com/isapi/redir.asp?Target=/vstudio/sp/vs6sp4/vbdownload.asp?id=10&x=8&y=10"

TARGET="_new">

http://msdn.microsoft.com/isapi/red...o/sp/vs6sp4/vbdownload.asp?id=10&x=8&y=10</A>

to download SP4. It has the fix for this problem.<br><br>Catrina<br>

 

[JonP46]

If you are using an ADODC connection JET 3.51 will not work with Access 2000.&nbsp;&nbsp;Change the Provider to JET 4.0.&nbsp;&nbsp;Maybe this code will help:<br><br>&nbsp;Option Explicit<br>' Be sure to set a reference to the Microsoft ActiveX Data<br>' Objects 2.0 Library.<br>Private rst As New ADODB.Recordset<br>Private cn As New ADODB.Connection<br><br>Private Sub Form_Load()<br>&nbsp;&nbsp;&nbsp;Dim strQuery As String ' SQL query string.<br><br>&nbsp;&nbsp;&nbsp;' First change the path to a valid path for your machine.<br>&nbsp;&nbsp;&nbsp;cn.ConnectionString = _<br>&nbsp;&nbsp;&nbsp;&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & _<br>&nbsp;&nbsp;&nbsp;&quot;C:\Jon\CIS\Data Warehouse\db1.mdb&quot; ' &lt;-Change this path.<br><br>&nbsp;&nbsp;&nbsp;' Open the connection.<br>&nbsp;&nbsp;&nbsp;cn.Open<br>&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;' Create a query that retrieves only four fields.<br>&nbsp;&nbsp;&nbsp;strQuery = &quot;SELECT&nbsp;&nbsp;x, y FROM xy &quot; ' Open the recordset.<br>&nbsp;&nbsp;&nbsp;rst.Open strQuery, cn, adOpenKeyset<br>&nbsp;&nbsp;&nbsp;' Set the DataSource to the recordset.