Re: Zugriff auf Access-Datenbank über ODBC

From: Martin Richter [MVP] (martin.richter_at_grutzeck.de)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 12:01:12 +0200

Hallo Ralf!

>> Ich verwende beim Open den DEFAULT_TYPE, setze
>> m_nDefaultType aber im Konstruktor des Recordsets auf
>> snapshot.
>
> Vielleicht probierst Du's dann doch mal mit "dynaset", denn
>
> aus der MSDN:
> CRecordset::snapshot <...>
> Changes made by other users are not visible until the recordset is
> closed and then reopened.

Requery ist genau die Funktion, die dies macht. Auszug aus der Doku:
If the recordset is a snapshot, you must call Requery to reflect edits by
other users as well as additions and deletions. 

-- 
Martin Richter [MVP] WWJD
"In C we had to code our own bugs. In C++ we can inherit them."
 FAQ : http://www.mpdvc.de
 Samples: http://www.codeguru.com http://www.codeproject.com

Relevant Pages

  • Re: Effects on RST in Calling Proc
    ... >> Obviously, the snapshot avoids that, but I think it's better to ... the recordset is snapshot and is passed to ... > the called proc so that another field can be searched for a value ... you avoid the issue entirely. ...
    (comp.databases.ms-access)
  • Re: MFC ODBC Consumer
    ... > I have two inherited MFC Recordset classes that connect to an access db file ... When I perform edit on the second one, the updates are ... A snapshot is as the name implies: it shows the data at the time it was ... A dynaset willl reflect changes made elsewhere (e.g. by others ...
    (microsoft.public.vc.database)
  • Re: Creating a form that is read only, but that will allow a search...
    ... Did you mean RecordSet Type of Snapshot? ... > Could anyone with half a computer brain (I don't even have an eighth ... > to change the form to 'edit' mode, so that I can make alterations ...
    (microsoft.public.access.gettingstarted)
  • Re: Snapshot or Dynaset type recordset
    ... Does using a Snapshot or ForwardOnly type recordset ... >> Jim F. ...
    (microsoft.public.access.formscoding)