Solved

microsoft access can't add rename or delete the control

Posted on 2014-02-09
3
1,455 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
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 84
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 2016 User Guides 5 33
Create Form using Wizard 14 35
Create Excel formula on dynamic data 5 35
Set focus on next field when character count = 5 9 12
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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…

896 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

17 Experts available now in Live!

Get 1:1 Help Now