You have to hook up with an Access2000 database at run-time, you cannot set
it with the properties window during design-mode.
First, make sure that in references you have a reference to the Microsoft
DAO 3.6 Object Library.
The following snippet is from the MS Knowledge base:
Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As String
Private Sub Form_Load()
sPath = "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs
<Do your stuff here>
End Sub
--
Ed Adamthwaite
Remove SpamMeNot to reply
Quote:
> Is there an update so that I can use an access 2000 database with VB6?
> If yes, where?
> Thank you,
> Amine