Fritz Paul
asked on
Why can I not rename or delete forms in Access 2010
I created an Access database in Access 2003 on one machine which runs XP.
I made a copy of this database on a Windows 7 machine which runs Access 2010.
I find now that I can not rename or delete forms in Access 2010.
I did not employ security on the database.
Any idea why, please?
I attach acopy of the database without the .mde.
Costingv2.zip
I made a copy of this database on a Windows 7 machine which runs Access 2010.
I find now that I can not rename or delete forms in Access 2010.
I did not employ security on the database.
Any idea why, please?
I attach acopy of the database without the .mde.
Costingv2.zip
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just compared two MDB's in A2010 .... see image.
The fact that Users and Permissions is an option in your db tells me this db has previously been secured ... I think.
mx
Capture1.gif
The fact that Users and Permissions is an option in your db tells me this db has previously been secured ... I think.
mx
Capture1.gif
And then again ... maybe not. Does not seem to be consistent ...
mx
mx
I tested your database in an Office 2003 VM, and I could both rename and delete forms.
On opening the database in Access 2010, I could rename but not delete (the Delete option was disabled). I checked Macro Security (the usual culprit), but it was set Low, so that wasn't the problem.
I made a brand-new .accdb database in Access 2010, and tried importing all objects into it. There were path errors on the tables, but other objects imported, and I was able to delete forms. I couldn't fix the links, but maybe there is a problem with the paths. You might be able to fix this problem by making a new database (of the desired format) and importing all objects into it.
On opening the database in Access 2010, I could rename but not delete (the Delete option was disabled). I checked Macro Security (the usual culprit), but it was set Low, so that wasn't the problem.
I made a brand-new .accdb database in Access 2010, and tried importing all objects into it. There were path errors on the tables, but other objects imported, and I was able to delete forms. I couldn't fix the links, but maybe there is a problem with the paths. You might be able to fix this problem by making a new database (of the desired format) and importing all objects into it.
I think that the fact that I could delete forms when running in Access 2003 at least rules out the possibility of user-level security being the cause of the problem.
Yeah ... doesn't seem ULS is it. In A2010, can rename ... no can delete ANY object.
Also ... see image.
mx
Capture1.gif
Also ... see image.
mx
Capture1.gif
ASKER
Hi, Thanks so far . I went for a rest meanwhile. 03:24 here now.
The db was never secured.
I downloaded helen's article.
First thing I am going to do is to look at the trust centre thing.
Then I will copy all to a new database and see if that works.
So let me first do that, and then come back to you.
Regards.
The db was never secured.
I downloaded helen's article.
First thing I am going to do is to look at the trust centre thing.
Then I will copy all to a new database and see if that works.
So let me first do that, and then come back to you.
Regards.
Pretty sure it's not the Trust Center issue, since my Trust Center is 'fine' ...
mx
mx
ASKER
I overcome the problem.
In the end I just copied everything over to a new 2003 database and then I could fully manage it with 2010.
I still don't know the reason, but I think the fact that helen could open it and manipulate in 2003 does not compl,etely rule out the user level security, because the default security group is present with a 2003 installation. Although I can not remember that I ever secured this database. I started working on it in February this year.
Your help is appreciated and gave me ideas to test. I want to try to accept multiple solutions.
In the end I just copied everything over to a new 2003 database and then I could fully manage it with 2010.
I still don't know the reason, but I think the fact that helen could open it and manipulate in 2003 does not compl,etely rule out the user level security, because the default security group is present with a 2003 installation. Although I can not remember that I ever secured this database. I started working on it in February this year.
Your help is appreciated and gave me ideas to test. I want to try to accept multiple solutions.
It's hard to say about ULS. Since ONLY Delete was disabled, that seems odd ... but who knows.
Write it off to ... WEIRD+
mx
Write it off to ... WEIRD+
mx
ASKER
Thanks to all.
That trick of creating a brand-new database and importing all objects into it often fixes weird, hard-to-diagnose problems.
However, Delete is grayed out ... humm.
mx