How does one force Access to write changes to disk at the end of a transaction in A2K using DAO?

I'm working from an example in Access 2003 VBA that says to use
the constant dbflushoscachewrites with the committrans statement.

This refuses to compile on my machine...... Is there another way to do this?

This is the statement that doesn'tcompile:

wrk.CommitTrans dbflushoscachewrites

Thanks,

Loralee

Without seeing all of the transaction code, it will be had to say where the problem is.

Might try just using:

wrk.CommitTrans



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com