Access: Problems opening file created in earlier version


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?

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Barry CunneyCommented:
I think the underlying file for VideoSoft vsFlex may be Vsflex32.ocx -
Barry CunneyCommented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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.


Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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!

Barry CunneyCommented:
I think it is a grid control a bit like the MS Flex Grid
good for working with DAO recordsets
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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:

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you both
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.