Access: Problems opening file created in earlier version

Posted on 2007-08-07
Last Modified: 2013-11-05

I am trying to open an Access file in Vista that was created in an earlier version.
An error is occurring because of trouble in the references.
If I look in Tools References in the VBE I get the following to broken
1) MISSING :-) VideoSoft vsFlex Controls
2) MISSING DAO 3.6 Object Library.

Would anyone be able to shed some light on this?

Question by:murbro
    LVL 17

    Expert Comment

    by:Barry Cunney
    The listed DLL's or OCX do not exist on the VISTA PC or exist in a different location.

    1. Open up the database on a PC that is working an go into Tools References and check what files  VideoSoft vsFlex Controls
    DAO 3.6 Object Library. refer to.

    When you select either one of them you should see the path of the underlying file in the bottom of the dialog.

    Check if these files exist on the VISTA PC

    With regards to the DAO one there may be a different version on VISTA so scroll down through the list of References and see if you can see any DAO one
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "2) MISSING DAO 3.6 Object Library."

    Most likely the problem.  It should be in the References list if you scroll down.  Microsoft DAO 3.6 Object Library

    "VideoSoft vsFlex Controls" ... I've seen that in the Insert Active X control list ... but now clue what it is.


    LVL 77

    Expert Comment

    You don't say what version of Access you are using but you will definitely have DAO3.6 installed on your machine.
    vsFlex is not a standard Access control so it must have been installed via another product.  You will have to install that from its source, assuming a Vista version is available and usable in Access.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "vsFlex is not a standard Access control so it must have been installed via another product. "

    Yeah ... I wonder where that comes from?  I suppose Google would tell us.  Odd that it was actually set as a reference!

    LVL 17

    Accepted Solution

    I think the underlying file for VideoSoft vsFlex may be Vsflex32.ocx -
    LVL 17

    Expert Comment

    by:Barry Cunney
    I think it is a grid control a bit like the MS Flex Grid
    good for working with DAO recordsets
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    murbro ...  once you get the References straightened out ... do this:

    A **DeCompile** may help here ...

    But first, if you have not already:
    Check for any **Missing References via the VBA Editor>>Tools>>References ....

    Then, follow this procedure:

    0) **Backup your MDB**
    1) Compact and Repair the MDB, as follows:
    Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
    2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
    3) Close the mdb
    4) Open the mdb and do a Compact and Repair (#1 above).
    5) Open the mdb:
        a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
        b) From the VBA Editor Menu at the top of the window:
            Note ... after the word Compile will see the name of your 'Project' - just an fyi.

    6) Close the mdb
    7) Compact and Repair one more time.

    *** Executing the DeCompile:
    Here is an example of the command line syntax  (adjust your path and file name accordingly) for executing the


    Run this from Start>>Run, enter the following command line ...

    "C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile


    For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:


    Author Comment

    Thank you both

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now