Editing mdb recordset through VBA

[Linda Mick]

First, if this has been addressed and I couldn't find it,
please feel free to respond privately.

In earlier versions of VBA, I was able to use
With... .Edit... !name = name... .Update... End with. I'm
using 2002 right now, and get an error that the data
member cannot be found on .Edit - I'm only
offered .Editmode. Did something change or am I missing a
library in my references? -Thanks!

 

[John Spencer (MVP)]

Probably you don't have DAO 3.6(?) as a reference.

Starting with Access 2000, Access defaults to ADO and doesn't automatically
include a reference to DAO.