Solved

microsoft access can't add rename or delete the control

Posted on 2014-02-09
3
1,558 Views
Last Modified: 2014-02-10
When I create a new form by selecting a table and pressing Create -> Form button...i then try to delete or modify objects on the form and I get the following msg.

"microsoft access can't add rename or delete the control"

This started happening recently. I created a new MS Access DB, created some new forms and tables and it still happens.

I am sure it's something to do with MS Access settings, not the project itself. Please help.
0
Comment
Question by:Dylan_E
[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
3 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 39846391
Hello Dylan_E,

Some access users reported that this error happened when they have 2 versions of access installed on their machine. This might be the cause of your issue.

Sincerely,

Ed
0
 
LVL 85
ID: 39846966
This can also happen is you don't have exclusive access to the file.

Close the database, then check the folder where that database is stored for a "lock file". A Lock File is a file created and maintained by Access, and it should be created whenever the database is opened, and then deleted when it's removed. It's named the same as the database except it'll have a .ldb or .accdb extension. So if I have a database named Customers.accdb, the lockfile will be named Customers.lccdb.

Also, be sure that your Windows and Access installs are fully up to date.
0
 

Author Closing Comment

by:Dylan_E
ID: 39848825
Ed, you are spot on.

I do have two versions 2007 and 2010. I do switch between them as I have clients who have different versions.

By re-opening the file in a different version, problem resolved.

Thank you.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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…

717 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