Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Value of dbFlushOSCacheWrites??

Posted on 1999-07-22
4
Medium Priority
?
412 Views
Last Modified: 2008-02-20
Access97 question: Can anyone tell me what the numeric value of the constant dbFlushOSCacheWrites is? I cannot find the constant in my object browser, nor can I use it in a module - I get a compile error: variable not defined. Although the constant is mentioned in the MS Access 97 helpfile and I am pretty sure I used the constant before...
0
Comment
Question by:kulikuli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
dsegard earned 80 total points
ID: 2001403
Hi,

Probably because it does not exist in ACC97. See below.


SYMPTOMS
========
 
Moderate: Requires basic macro, coding, and interoperability skills.
 
The Microsoft Access 97 Help topic "BeginTrans, CommitTrans, Rollback Methods" contains the following statements.
 
In the Syntax section:
 
   workspace.BeginTrans|CommitTrans[dbFlushOSCacheWrites]|Rollback
 
In the third paragraph of the Remarks section:
 
   In a Microsoft Jet workspace, you can include the dbFlushOSCacheWrites constant with CommitTrans. This forces the database engine to immediately flush all updates to disk, instead of caching them temporarily.
 
These statements are incorrect.
 
RESOLUTION
==========
 
The dbFlushOSCacheWrites constant was changed to dbForceOSFlush in Microsoft Access 97. Use the dbForceOSFlush constant or its numeric value, which is 1.
 
MORE INFORMATION
================
 
The dbForceOSFlush constant only works if your database resides on a Microsoft Windows 95 or Windows NT computer. If the database file resides on another type of server, such as Novell Netware or Banyan Vines, dbForceOSFlush does not correctly command the operating system to flush all
updates to disk.



DS
0
 
LVL 3

Expert Comment

by:dsegard
ID: 2001404
I forgot to mention : taken from technet. Pardon Bill...

(Topic : ACC97 CommitTrans Help Topic Uses dbFlushOSCacheWrites Constant)

DS
0
 
LVL 5

Author Comment

by:kulikuli
ID: 2001405
dsregards, I just made me VERY VERY HAPPY with the above information!! Thanks alot!! I've been spending some hours to find a solution to this problem.

Thanks again.
0
 
LVL 3

Expert Comment

by:dsegard
ID: 2001406

I understand what you feel - that does not explain why MS force us to respect the rules it does not respect about compatibility...

DS
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question