Solved

ACCESS 2003 Edit file

Posted on 2011-03-21
2
244 Views
Last Modified: 2012-05-11
Hi Experts

i have a file that i opened in access 2003 and I’m getting a message that says that i have a problem with OLE or activex controller,
i have tried to edit a field and then the message appear.

What can i do to make the file editable?
0
Comment
Question by:IT_Group1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 35182554
I would suspect that you either (a) have a corrupt file or (b) have reference issues.

Are you using ActiveX controls in the application? If you are, then you'll have to insure that you have the design-time version of those controls on your machine.

If you're not, then try this:

Make a backup, then Compact your database. After doing that, try to Compile your databse - from the VBA window, click Debug - Compile. Fix any errors, and continue this until the menuitem is disabled. Now Compact again.

If that doesn't fix your issue, try moving everything into a new, blank database. Then compact - compile - compact again.

If that doesn't fix your issue, review your References (from the VBA editor, click tools - references). Post those references here and we'll review them.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35184466
Yes, and also take a moment to describe what type of data this field is supposed to contain.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 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