Re: ADO recordset doesn't see DB changes

Bob,

Just wanted to let you know that by executing a Resync() of recordset 2,
after recordset 1 has completed it's update, fixed the problem.

Thanks for your help
Neil

"Bob Barrows [MVP]" wrote:

Neil B wrote:
Interesting information regarding the way the Jet Engine works.
I read the intro to the articles and they indicated that the problem
you think is the culprit arises if you have 2 connection paths to the
database. The way my app is set up there is only 1 connection path to
the DB (that is I only open the database once) which both recordsets
use. I gathered from what I read that this problem required 2
connections.

I'm not sure, but I think the provider is unable to support more than
one cursor at a time per connection. I suspect what is happening behind
the scenes when you open the second recordset is that, instead of
returning an error, it is opening a second implicit connection to
provide the second cursor, thus leading to the delayed-write issue.

Also, when I ran the app in debug mode I stopped after recordset2 did
it's changes and stepped thru the recordset1 read code a record at a
time (I was not in a hurry) and the changes were not reflected. I
would think the database would have been updated by then no matter
how lazy it was. There was nothing else running on the system at the
time.

Am I interpretting this right?


I'm not sure, but it couldn't hurt to try the remedy suggested by the
second article, could it?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.

Relevant Pages

  • Re: Connection types and speeds
    ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
    (microsoft.public.access.queries)
  • Re: VBA - "Out of stack space" error
    ... written for AutoCAD VBA generates an 'Out of stack space' ... I create the ADODB connection... ... > ' If the connection to the database has been opened ... where I try to open the recordset. ...
    (microsoft.public.vb.database.ado)
  • Re: adodb
    ... without knowing how the database is implemented. ... required to access a database when using ADO, although one can use ADO to ... A Connection object represents a unique session with a data source. ... A Recordset object represents the entire set of records from a base table ...
    (microsoft.public.vb.database.ado)
  • Re: adodb
    ... > without knowing how the database is implemented. ... > required to access a database when using ADO, although one can use ADO to ... > A Connection object represents a unique session with a data source. ... At any time, the Recordset object ...
    (microsoft.public.vb.database.ado)
  • Re: strange slowness with getrows method
    ... how many fields in the recordset? ... Can you try using the native OLEDB provider for your database rather than ... I notice that you are using the bad practice of supplying a connection ... > table to use the more efficient getrows method. ...
    (microsoft.public.inetserver.asp.db)