🚀 go-pugleaf

You probably use client-side cursor. In this mode TADODataSet (TADOTable,
TADOQuery) fetches all rows into in-memory cache. So you will not see
changes without calling Requery() - that is true for any DBMS.

Jet unlike other DBMS can delay writes to disk. Search for "Jet flush"
(without quotes) in MSDN and you will see some articles that describe flush
properties, such as "Jet OLEDB:Shared Async Delay", "Jet OLEDB:Flush
Transaction Timeout".

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Stefano Dardari" <s.dardari@tin.it> �������/�������� � �������� ���������:
news:40154b51@newsgroups.borland.com...
> Hi Viatcheslav V. Vassiliev,
>
> > If database is not too big (up to some MB) - it is a good solution.
> >
> > If one user modifies a record, there may be some seconds delay until
other
> > users will see changes.
>
> But it must be specified some particular connecttion string or set some
> special parameter to get this sincronization ?
>
> I've tryed in local, with 2 application running on same DB, if I
> insert/delete or modify a record on the other Application I can't see any
> changes, also after one minute.
>
> Must I have to wait for a particular event ?
> I've not found any explanation at all around the web.
>
> Thanks for any help.
> Steve
>
>