OpenRecordSet

[Alan T]

Is the OpenRecordSet returns the isolated record set or a live record set?

After I called the OpenRecordSet of a table, if someone add a new record to
the same table then does it affect my recordset?
Will this new record also be added to my record set?

 

[Guest]

When you open a recordset, it is unique to your instance. If another user
adds, deletes, or modifies a record, it will not affect your recordset until
you requery; however, if you attempt to read a record that has been deleted
or add a record with a primary key that has been inserted, you will get an
error.

 

[Perry]

After I called the OpenRecordSet of a table, if someone add a new record

to the same table then does it affect my recordset?
Will this new record also be added to my record set?

Nope ...

By the time your OpenRecordSet dataset is opened, it hasn't updated current
changes to the
the various tables changes were made to ...
If you're lucky they have, but lucky isn't the standard we developers would
like to rely on.

--
--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE