Updating Speed of MS Access

[Pietjeparasietje]

Hi all,

I've got the following problem.
I've got a Delphi program showing all the records in a Access table.

The when I insert a record into access and refresh my list in Delphi the new record isn't shown. Just after 4 or 5 refreshes it's shown.

This is really slowing down my program. Is it just that access is to slow or am I doing something wrong?

Thanks,

Peter

 

[jbpelletier]

hi,

Maybe it could be a "post" problem? if it is.. before a refresh use a .post

jb

 

[Pietjeparasietje]

Thanks, But that's not the problem.
It happens actually more often in other programs. And right then the only way to fix it is to delay the program for 1 second or so, or give a showmessage, before continuing to the next step. Otherwise he won't find the data.

Peter

 

[whosrdaddy]

Hi,

you must set the TADOConnection.Cursorlocation property to clUseServer if you want to have the latest data or a "direct" link between the db provider and delphi. please note that this setting will prevent caching of data (that is what you are experiencing) so some datacontrols will behave not the way you'll expect (like the DBGrid).

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!