Solved

ACCESS 2003 Edit file

Posted on 2011-03-21
2
233 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
2 Comments
 
LVL 84

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

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…
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…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 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