Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 859
  • Last Modified:

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
0
Fritz Paul
Asked:
Fritz Paul
  • 7
  • 4
  • 3
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I'm in A2010 now and I just renamed one of your Forms ...

However, Delete is grayed out ... humm.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Are you *positive* this db was never secured with A2003 User Level Security ?

mx
0
 
Helen FeddemaCommented:
My most recent Access Archon article deals with disabled databases (something that often happens when a database is upgraded from 2003 to 2010).  Try running through the fixes in this article:

http://www.helenfeddema.com/Files/accarch208.zip
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
And then again ... maybe not.  Does not seem to be consistent ...

mx
0
 
Helen FeddemaCommented:
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.
0
 
Helen FeddemaCommented:
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.

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yeah ... doesn't seem ULS is it.  In A2010, can rename ... no can delete ANY object.

Also ... see image.

mx
Capture1.gif
0
 
Fritz PaulAuthor Commented:
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.

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Pretty sure it's not the Trust Center issue, since my Trust Center is 'fine' ...

mx
0
 
Fritz PaulAuthor Commented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It's hard to say about ULS.  Since ONLY Delete was disabled, that seems odd ... but who knows.

Write it off to ... WEIRD+

mx
0
 
Fritz PaulAuthor Commented:
Thanks to all.
0
 
Helen FeddemaCommented:
That trick of creating a brand-new database and importing all objects into it often fixes weird, hard-to-diagnose problems.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now