Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 25th, 2005, 11:14 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default flushing buffer in A2K

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



Old September 26th, 2005, 05:44 PM
Friend of Wrox
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts

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

Might try just using:


"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Flushing datatable to an Excel file... livehed General .NET 0 January 13th, 2006 08:21 AM
Hiding Objects In A2K PC User Access VBA 3 May 5th, 2005 06:44 AM
Can A97 and A2K co-exist? Clive Astley Access 8 November 25th, 2004 12:57 PM
using oledb to retrieve data from sql server w A2K nikesierra2306 Access VBA 0 October 20th, 2004 04:36 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.