Re: Refresh Cache

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/20/04

  • Next message: William \(Bill\) Vaughn: "Re: Hi Wlliam" 
    Date: Tue, 20 Jul 2004 10:50:58 -0700

    Yes, this has been discussed (many times) before. I would search Google for
    tips.
    Offtimes we simply wrap the operation (the UPDATE) in a transaction. The JET
    gurus know about other options that you can set... but I don't work much
    with JET (I spend more time trying to convince folks to switch to SQL
    Server/MSDE/SQL Express that do not have these issues.

    Incidentally, JET is not a good choice for a web site... MSDE is far more
    suited for this task. 

    -- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Robert Eliasson" <robert@gnetech.com> wrote in message
news:eToMuFibEHA.4092@TK2MSFTNGP11.phx.gbl...
> Hi!
>
> I must be the last one on the planet to know.
>
> I use a JET database for a webpage. When I delete rows it doesn't reflect
on
> the page. I assume it has to do with the caching of the JET object. Does
> anyone know how to refresh this stuff. I do not want to use JRO for as far
> as I can understand it requires a ADO conncetion (as opposed to a ADO.NET
> connection).
>
> Isn't it weird how hard it is to find onfo about this as it must be a
major
> issue for all developers?
>
> Grateful for tips!
>
> !Robert
>
>
>
> PS I am using code like:
>
> System.Data.OleDb.OleDbConnection cn;
> cn = new System.Data.OleDb.OleDbConnection();
> cn.ConnectionString =
>
System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString
> ").ToString();
> cn.Open();
> System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
> cmd.Connection = cn;
>
>
>
>
>
>
  • Next message: William \(Bill\) Vaughn: "Re: Hi Wlliam"

    Relevant Pages

    • Re: Deleting a record
      ... Is there a way to refresh the Access table using a query? ... although ProcessA had written a set of rows (in a transaction), ... FROM the disk tables ... exposed by the Microsoft Jet OLE DB provider called "JET OLEDB:Transaction ...
      (borland.public.delphi.database.ado)
    • Re: commit or rollback a transaction without first beginning a transaction
      ... Excerpt from the Jet Programmer's Guide: ... "When a transaction is explicitly started (by calling SQLSetConnectOption ... application has two active statements within an explicit transaction; ... are committed, but in addition, the recordset generated by ...
      (microsoft.public.access.modulesdaovba)
    • Re: problem in update where duplicates in both files exist
      ... Jet is the "database engine" that is behind Access. ... >> I have a table of raw data containing some records with identical data. ... I want to update the first table with the transaction numbers. ...
      (microsoft.public.access.queries)
    • Re: Code works without Transaction, but not with
      ... issue relating to converting between different versions of JET. ... I did report this issue to MS, but I was not able to get permission from the ... >> DAO transaction or ADO? ...
      (microsoft.public.access.modulesdaovba)
    • Re: ADO.net Code contest
      ... > Try beginning a transaction before these updates and see what ... As it is JET won't write these rows to the database until ... > to JET's database cache in memory. ...
      (microsoft.public.dotnet.framework.adonet)