"Method or Data Member Not Found" and it's highlighting ".Edit&qu

[Sillygirl]

I have an old VB6 program that is being updated to use ACCESS 2007 database. I'm getting this error "Method or Data Member Not Found" and it's highlighting ".Edit" and have no idea what is causing it. Could it be the references?

If timecheck!Runweek <> Runweek Then
timecheck.Edit ****<----this is the statement******
timecheck!Runweek = Runweek
timecheck.Update
Set tblRunweek = dbase2.OpenRecordset("RunWeek")
While Not tblRunweek.EOF
tblRunweek.Delete
tblRunweek.MoveNext
Wend
tblRunweek.Close
End If
Thanks in advance!
- Sillygirl

 

[Sillygirl]

Thanks all - solved it myself!

 

[nickd87]

Could you please post how you solved it.

 

[strongm]

I'd imagine that it is the difference between a DAO recordset and an ADO recordset. In other words the answer to the OP's "Could it be the references?" is "yes". And I imgine Sillygirl figured this out.