dbForceOSFlush for ADO Connection object

Posted on 2006-04-21
Last Modified: 2008-02-01
Does the ADO Connection object have something similar to dbForceOSFlush?
Question by:Milewskp
    LVL 58

    Accepted Solution


    ADO is not too concerned about the actual engine used. However, you can get a direct handle on the active JetEngine, and force the database cache flush from there. For early binding, this will require a reference to "Microsoft Jet and Replication Objects ?.?? Library" (or JRO for short).

    Full example and more details in ADO help, keyword "RefreshCache Method".

    As a one-liner for a Jet Connection (late binding):

        CreateObject("JRO.JetEngine").RefreshCache CurrentProject.Connection

    Hope this helps!
    LVL 1

    Author Comment

    Works for me. Thanks!
    LVL 58

    Expert Comment

    Great! Thanks for points and grade!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now