Re: update problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: xarrisx (xarrisx_at_softhome.net)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 08:13:06 +0300

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:ONjBtfRsEHA.2316@TK2MSFTNGP12.phx.gbl...
> xarrisx wrote:
> > I am using an Insert command in my asp code that Inserts a rows in my
> > database.
> > After the Insert command i create a recordset and ask for all the
> > rows in the table that i aplied the insert command
> > Some times the rows i get are correct but sometimes the database is
> > not updated by the time the recordset is opened.
> >
> > Is there any way to wait until the table is updated with the new rows
> > and then open the
> > recordset?
> <snip>
> > I am using access and dsnless conection
>
> The connection type does not matter. However, if you are not using the
> native Jet OLEDB provider, I suggest you do so. See
> www.able-consulting.com/ado_conn.htm for examples.
>
> You are falling victim to a performance enhancement in Jet:
update-caching.
> I'm a little surprised about this as you are not using a cursor to do your
> insert. However, see these KB articles:
> http://support.microsoft.com/?kbid=240317
> http://support.microsoft.com/kb/200300
>
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
thanks for the link
http://support.microsoft.com/?kbid=240317

Searching for more info on "JetEngine object's RefreshCache Method" i found
the following:

I adjust this setting to the registry

Go HKEY_LOCAL_MACHINE/Software/Microsoft/Jet/4.0/Engines/Jet/4.0/
           ImplicitCommitSync should be set to yes
           UserCommitSync should be set to yes.

As it mentions it has some performance penalty but it works fine

I suppose this affects all web sites in my web server. I am now looking for
a function to add in my asp code that will immediately refresh the
read-cache after the insert in my current connection.

Relevant Pages

  • Re: Problem on quering Access link table
    ... Is "Alias" a field in the Exchange table? ... > simply test the recordset for BOF/EOF? ... > Access Database Samples: www.rogersaccesslibrary.com ... I wrote ASP code to use Alias ...
    (microsoft.public.access.queries)
  • Re: Data Has Been Changed Issue
    ... Database & recordset variables should be desassigned before you exit ... > I am using command buttons to call code from modules. ... > Public Sub DeleteChargeOffRecords() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report parameters and text options
    ... I am working from a copy of the old database. ... I open the report from a command button. ... The strCertSQL is actually more complex than that, ... that vendor from the recordset. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Accessing Jet Engines in Asp. Please help - A critical deadline is closing in.
    ... Does it fail when you call AddNew method of ADO recordset? ... The product works fine on IIS ... The database is now ready and the client wishes to go ... > When we run the proven asp code on IIS in an XP Pro machine with the new ...
    (microsoft.public.vb.database.ado)
  • getting returned value from stored procedure
    ... I'm using Command to try to get the returned values of a stored procedure ... How do I set the returned value as a recordset? ... Please make sure the database is available and the connection ...
    (borland.public.delphi.database.ado)