OpenRecordSet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan T - 21 May 2007 12:51 GMT

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?

Reply to this Message

Klatuu - 21 May 2007 13:16 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

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

Reply to this Message

Perry - 21 May 2007 20:54 GMT

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

Signature

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

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

Reply to this Message