Write Data to Disk and not Cache

[seamus]

Hi
My database resides on another machine and I access it
from my machine. When I add a record, it does not appear
in my requery action (which should display the new record
in a subform)

Is this because Access 97 writes to Cache and not the
disk immediately.
And if so how can I solve it.

I hope you can understand my problem and provide a
solution

thanks for any help

 

[[MVP] S. Clark]

**Although the name of this newsgroup is 'Queries',
it is actually referring to the Access Database Query Object.**

I think no on the Cache question, meaning that it writes it as soon as you
see the pencil disappear from the record selector.

Probably the timing of your requery action is incorrect. When/Where are you
telling it to requery?

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-