470,594 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

Object owner can't change security

Hi,

I have a secured Access 2000 database, and have encountered a strange
error that I can't find any similar postings on. I'd really appreciate
your help!

In my database, I have a number of local tables as well as a number of
linked tables. The User that I have logged in as ("Developer1") is the
owner of all objects and is Administrator. In the User and Group
Permissions box, under Change Owner, Developer1 is the current owner
of all objects.

I have tried to delete the link to one of the linked tables, however
receive the error "You don't have permission to delete <table name>.
To delete this object, you must have Modify Design permission for
it...". I immediately checked in the Change Owner tab of the User and
Group Permissions box, and sure enough Developer1 is the Current Owner
AND the Current User.

Any possible suggestions?? It's incredibly frustrating as it seems
this object has no "owner" as it won't recognise who should be it's
owner - and so is untouchable.

Thanks, Ange
Nov 13 '05 #1
1 4695
Hi, Ange.

Did you accidently uncheck the "Modify Design" or "Administer" check boxes
for that linked table within the Permissions section of the "User And Group
Permissions" dialog window? That might explain the message you are getting.
The only other thing I can think of is database corruption.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
"Ange T" <sm*************@yahoo.com> wrote in message
news:b7**************************@posting.google.c om...
Hi,

I have a secured Access 2000 database, and have encountered a strange
error that I can't find any similar postings on. I'd really appreciate
your help!

In my database, I have a number of local tables as well as a number of
linked tables. The User that I have logged in as ("Developer1") is the
owner of all objects and is Administrator. In the User and Group
Permissions box, under Change Owner, Developer1 is the current owner
of all objects.

I have tried to delete the link to one of the linked tables, however
receive the error "You don't have permission to delete <table name>.
To delete this object, you must have Modify Design permission for
it...". I immediately checked in the Change Owner tab of the User and
Group Permissions box, and sure enough Developer1 is the Current Owner
AND the Current User.

Any possible suggestions?? It's incredibly frustrating as it seems
this object has no "owner" as it won't recognise who should be it's
owner - and so is untouchable.

Thanks, Ange

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ajay | last post: by
3 posts views Thread by Martin Knopp | last post: by
7 posts views Thread by Dave Coate | last post: by
3 posts views Thread by Dave Coate | last post: by
6 posts views Thread by kai rosenthal | last post: by
1 post views Thread by Teresa Masino | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.