Type Database and Access20000

[Guest_imported]

I used this in Access97, and I want to use the same function in Access 2000. This isn't working because 2000 does not know the "Database" type. What type is used within 2000.

Dim rst As Recordset
Dim db As database
Set db = CurrentDb
Set rst = db.OpenRecordset("Klanten", dbOpenDynaset)
With rst
.AddNew
![KLnaam] = Me.KLnaam
.Update
End With

Thanks
Jordi

 

[CPUburn]

Hi there,

The problem you have is that you probably don't have a reference to a DAO 3.6 library in your db.

just pick Tools - References - and check Microsoft DA0 3.6 object library

this should do the trick

the kid