M
mike
HI all,
I wrote the code for DAO for inserting, adding, etc. At
the end of inserting datas to tables, do you need to close
it?
For example:
Dim db As DAO.Database
Dim rst AS DAO.Recordest
set db=Currentdb()
set rst=db.openrecordset(somthing)
With rst
.Addnew
.....
.update
End With
rst.Close // Right at this point, do you need to add this
in it? If so, how can check to see if this code close/end
the rst? How can you check to see if it is close or not by
using boolean?
Any suggestion??
Mike
I wrote the code for DAO for inserting, adding, etc. At
the end of inserting datas to tables, do you need to close
it?
For example:
Dim db As DAO.Database
Dim rst AS DAO.Recordest
set db=Currentdb()
set rst=db.openrecordset(somthing)
With rst
.Addnew
.....
.update
End With
rst.Close // Right at this point, do you need to add this
in it? If so, how can check to see if this code close/end
the rst? How can you check to see if it is close or not by
using boolean?
Any suggestion??
Mike