ADO CACHE



Hi all,
i'm using ADO to access my backend DB for an application.

I've a single global connection that I use for all the table and
dataset I create in runtime that is initialized in this way:

M_CONNECTION := TADOConnection.Create(application);
M_CONNECTION.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mioDB.mdb;Jet OLEDB:
Engine Type=4';
M_CONNECTION.Mode := cmShareExclusive;
M_CONNECTION.ConnectOptions := coConnectUnspecified;
M_CONNECTION.IsolationLevel := ilBrowse;

I encounter problem with cache when I add a new record in a table and
immediatly I access it from a new table component that is using always
the same connection.
I noted that if I call two time the same function that do the user
output of the database content I can see the correct output. Calling
the function only a single time I've not the new record showed and I've
to wait a new refresh.

I cannot understand what kind of problem I've please help me.

Thanks in advance,
Paolo

.