OpenRecordSet

A

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?
 
K

Klatuu

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.
 
P

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?
Click to expand...

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
 
Top