Refresh Disconnected recordset?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Damon - 28 Oct 2004 11:01 GMT

Hi,

I have a disconnected recordset, this recordset could hold 1 record or
several records. If for instance it holds one record and I want to then
save my form so that there will then be two records in the database, I want
to be able to reconnect the disconnected recordset, refresh it with the
saved record and then disconnect it. So that I can then switch between the
two records. I have tried recordset.requery but it comes back with an
error, any help on this would be appreciated.

Thanks

Damon

Reply to this Message

Mark J. McGinty - 29 Oct 2004 15:51 GMT

Open the recordset using adLockBatchOptimistic as the lock type. Your
new/changed records will be visible as soon as they are added/updated. To
send them to the database, reconnect and call UpdateBatch. If you need to
see identity values generated by the database, you may need to use
adOpenKeyset as the cursor type.

-Mark

> Hi,
>
[quoted text clipped - 11 lines]
>
> Damon

Reply to this Message

VB Forum / Database Access / October 2004

Refresh Disconnected recordset?