[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

Access: Problems opening file created in earlier version

Hi

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
references:
1) MISSING :-) VideoSoft vsFlex Controls
2) MISSING DAO 3.6 Object Library.

Would anyone be able to shed some light on this?

Thanks
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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.

mx

0
 
peter57rCommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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!

mx
0
 
Barry CunneyCommented:
I think the underlying file for VideoSoft vsFlex may be Vsflex32.ocx -
0
 
Barry CunneyCommented:
I think it is a grid control a bit like the MS Flex Grid
good for working with DAO recordsets
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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:
       >>Debug>>Compile
        Note ... after the word Compile ...you 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

decompile:

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

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

"C:\Access2003Clients\AzDoc\Pgrm\AzDocPgrm2K3.mdb"

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

http://www.trigeminal.com/usenet/usenet004.asp?1033

mx
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you both
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now