Solved

microsoft access can't add rename or delete the control

Posted on 2014-02-09
3
1,432 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
3 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
Comment Utility
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 84
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
Outlook Free & Paid Tools
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

743 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

8 Experts available now in Live!

Get 1:1 Help Now