How can I implement an Access 2000 database in VB6 ??
When I have tried, all i get is an "unrecognised file format"..
Thanks

- Richard Volpe

Use DAO 3.6 or ADO.
DAO 3.51 not read Access 2000.
If you use control Data and DAO (Data don't work with DAO 3.6), then
following code help you

Set db=Workspaces(0).OpenDatabase("MyDB")
Set Data1.Recordset=db.OpenRecordset("Query")

Best regards

You need the latest version of  Microsoft DAO (Microsoft DAO 3.6 Object
Library). Goto
http://www.microsoft.com/data/download.htm
and download MDAC 2.1.2.4202.3 (GA) (choose downloads
from side panel of webpage and you should find it.) After you've downloaded
the .exe file run it on your hard drive. In VB choose References from the
Project menu. Find the Microsoft DAO 3.6 Object Library check box in the
list and select it. Make sure you unselect the old DAO version (probably DAO
3.51). This should work. I hope this helps.  L.B.