Solved

microsoft access can't add rename or delete the control

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Outlook Free & Paid Tools
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

773 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