Very Computer

I am trying to use this to no avail:
****************************************************************************
****
set rs = db.openrecordset("table",dbOpenDynaset,dbAppendOnly)

with rs
        .Addnew
        !name = "Tim"
        .Update
        .Close
end with
****************************************************************************
****
it's in the load event of two different forms that are loaded sequentially.
 What is going on?  It tells me that the record is locked when I load it
the second time.  It appears to me that since the recordset is closed, the
record is NOT locked.

Are my questions too hard or easy (or just stupid!) because nobody is
answering them.  Someone please help me.

Thanks in advance,
Tim McLaughlin

Quote:> Tim,

> Are you closing the database object once your finished with the
recordset?
> If not you need to and this is probably your problem.

No I was not, but it turns out that the problem was due to the (seemingly)
erratic fire of events (record moves) by the data control.  I had been
using it because I didn't want to code all of the fields I was displaying.
I decided to trash those controls and manage the recordsets with code.  It
solved the problem.  (and I thought that data controls had their place,
boy, was I wrong)

Sincerely,
Tim McLaughlin

Two things.

1.  Don't use the data control.  It's just not worth the
trouble.

2.  Whenever you finish an update, Access leaves the dirty
work of actually finishing the operations to Idle time.  You
need to force Idle time with

DBEngine.Idle dbFreeLocks

This will force the idle time and free up locks.

Your code should look like this.

with rs
        .Addnew
        !name = "Tim"
        .Update
        .Close
end with
DBEngine.Idle dbFreeLocks