By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,862 Members | 868 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,862 IT Pros & Developers. It's quick & easy.

Object owner can't change security

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.