Object owner can't change security

[Ange T]

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

['69 Camaro]

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