Hi All,

Access 2000 does not recognise the .Edit statement in my modules any more.
For Example this code generates the compile error: "Invalid use of property."

    With MySet
      .Edit
      !MyField = "Something"
      .Update
    End With

I presume that I have forgotten to load a library. Does anyone know which one?

Thanks,
Frans.

Hello All,

I made a silly mistake in my previous mail. This is the correct one.

Access 2000 does not recognise the .Edit statement in my modules any more. For Example this code generates the compile error: "Method or Data
member not found."

     With MySet
      .Edit
      !MyField = "Something"
      .Update
     End With

I presume that I have forgotten to load a library. Does anyone know which one?

Thanks,
Frans.

I solved the problem by explicitly declaring
Dim MyDB AS DAO.Database
where befor I had
Dim MyDB AS Database
but I still don't know why this solved the problem.

Kind regards,
Frans.

Access2000 and 2002 default to using the ADO (ActiveX Data Objects)
model. Both ADO and DAO have recordset objects... but they are
DIFFERENT recordset objects. In particular, the ADO recordset is open
for editing immediately and therefore does not have or need an Edit
method.

It's best to explicitly choose which library you're using; in
addition, it would be wise to Dim rs As DAO.Recordset so you know what
you're getting.

                  John W. Vinson[MVP]    
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public