Solved

Access 2007 fill-in form error VSFLEX7L.OCX reference missing or broken

Posted on 2011-02-11
3
1,457 Views
Last Modified: 2012-05-11
When running an Access 2007 form, this error appears:  

Microsoft Office Access database or project contains missing or broken reference to the file 'vsflex7L.ocx' version 1.0

This error occurs for all users except the original form creator.  It occurs 3 times, cleared by OK, then form appears and seems to function.

Here's the help given for the error:

________
The application you are attempting to use has a reference that it cannot resolve to an object, type library, DLL, or external database.  Either the object, type library, DLL, or database was deleted or renamed. Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required. If you did not create this application, contact the programmer or administrator of the system.

If the reference listed in the Available references list is preceded with "MISSING:" clear the check box to remove the reference if it is no longer required. If you still need to use the reference, clear the check box entry for "MISSING: <referencename>" in the Available references list, and then create a new reference to the file using the Browse... button. If this is an installed database application, you may need to reinstall or repair the application.
_________

I can find links to ocx free scanners, etc., on Internet but not much additional info other than it is somehow related to .dll.

Can anyone explain what this is, how to stop the error and/or if it can be safely ignored.

Thanks!
0
Comment
Question by:ColdKathleen
3 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 200 total points
ID: 34877935
Are you using this FlexGrid in your application?

Have you done what it suggests in Help?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 300 total points
ID: 34878126
In many cases, the control is no longer needed. To test, you can do this:

1) Make a backup of your database
2) From the VBA Editor, click Debug - Compile. Fix any errors, and continue doing this until the menuitem is disabled
3) Now remove that reference - again, in the VBA Editor, click Tools - References, and remove it.
4) Now compile again. If you don't receive any additional errors, chances are that you don't need that reference.
0
 

Author Closing Comment

by:ColdKathleen
ID: 34889228
First answer a good clue, 2nd answer had resolution steps.  Both appreciated!  Thanks.
0

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

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Access 2016 - Query Challenge 15 51
Combobox issue 4 27
Minus first query 1 6
Join vs where 2 11
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
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…

747 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

11 Experts available now in Live!

Get 1:1 Help Now