Re: how do I change ownership of and "unknown" owner

From: TC (no_at_email.here)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 13:06:05 +0930

Eric, sorry to take issue with you twice in one day, but the most common
cause of an object's owner being 'Unknown', is that the user is using the
wrong workgroup file. That is, the object is owned by a SID that does not
exist in the current workgroup file.

HTH,
TC

"Eric Butts [MSFT]" <ebutts@online.microsoft.com> wrote in message
news:mMb4qTNHEHA.2944@cpmsftngxa06.phx.gbl...
> Hi Chris,
>
> The Administrator you are talking about should be the Administrator of the
> database and not your machine Administrator. Access security has nothing
> to do with NT or machine level security.
>
> Again, if the objects you are having problems with have 'Unknown' for
> Owner, in all my experience it's been corruption. Do a Google search for
> "database recovery", "access" if you can't resort to back up copy.
>
> Regards,
>
> Eric Butts
> Microsoft Access Support
> ebutts@online.microsoft.com
> "Microsoft Security Announcement: Have you installed the patch for
> Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
> you to review the information at the following link regarding Microsoft
> Security Bulletin MS03-026
> <http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
> to visit Windows Update at <http://windowsupdate.microsoft.com/> to
install
> the patch. Running the SCAN program from the Windows Update site will
help
> to insure you are current with all security patches, not just MS03-026."
>
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> --------------------
> | Content-Class: urn:content-classes:message
> | From: "Chris" <christopher.h.hines@jci.com>
> | Sender: "Chris" <christopher.h.hines@jci.com>
> | References: <161d501c41be6$09a4a670$a601280a@phx.gbl>
> <rXhKkMEHEHA.3704@cpmsftngxa06.phx.gbl>
> | Subject: RE: how do I change ownership of and "unknown" owner
> | Date: Wed, 7 Apr 2004 06:52:16 -0700
> | Lines: 89
> | Message-ID: <19af801c41ca7$897e52d0$a101280a@phx.gbl>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="iso-8859-1"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> | Thread-Index: AcQcp4l+musPauqPRyS16aEXoIaqGA==
> | Newsgroups: microsoft.public.access.security
> | Path: cpmsftngxa06.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9764
> | NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
> | X-Tomcat-NG: microsoft.public.access.security
> |
> | Well I can get on a machine inwhich the security features
> | were not turned on and I can access the data fine. But
> | when I try to import the reports to the secured
> | machine . . . it tells me I do not have exclusive rights
> | and my settings will not be saved. I am logged in as
> | admin. I think there is something wrong with my
> | administrator rights. I also would not let me export
> | from the clean machine to the secured one. I am really
> | confused.
> |
> | Thanks for any help you can give. If it would help, I
> | can email a copy of the database to whomever thinks they
> | can help.
> |
> | >-----Original Message-----
> | >Hi Chris,
> | >
> | >If your objects are showing Owner as 'Unknown' then it's
> | most likely a
> | >corruption issue. Thereby, you will need to resort to a
> | good backup copy
> | >of the object in your backup database.
> | >
> | >
> | >Regards,
> | >
> | >Eric Butts
> | >Microsoft Access Support
> | >ebutts@online.microsoft.com
> | >"Microsoft Security Announcement: Have you installed the
> | patch for
> | >Microsoft Security Bulletin MS03-026? If not Microsoft
> | strongly advises
> | >you to review the information at the following link
> | regarding Microsoft
> | >Security Bulletin MS03-026
> | ><http://www.microsoft.com/security/security_bulletins/ms0
> | 3-026.asp> and/or
> | >to visit Windows Update at
> | <http://windowsupdate.microsoft.com/> to install
> | >the patch. Running the SCAN program from the Windows
> | Update site will help
> | >to insure you are current with all security patches, not
> | just MS03-026."
> | >
> | >This posting is provided "AS IS" with no warranties, and
> | confers no rights
> | >
> | >
> | >--------------------
> | >| Content-Class: urn:content-classes:message
> | >| From: "Chris" <anonymous@discussions.microsoft.com>
> | >| Sender: "Chris" <anonymous@discussions.microsoft.com>
> | >| Subject: how do I change ownership of and "unknown"
> | owner
> | >| Date: Tue, 6 Apr 2004 07:47:09 -0700
> | >| Lines: 9
> | >| Message-ID: <161d501c41be6$09a4a670$a601280a@phx.gbl>
> | >| MIME-Version: 1.0
> | >| Content-Type: text/plain;
> | >| charset="iso-8859-1"
> | >| Content-Transfer-Encoding: 7bit
> | >| X-Newsreader: Microsoft CDO for Windows 2000
> | >| X-MimeOLE: Produced By Microsoft MimeOLE
> | V5.50.4910.0300
> | >| Thread-Index: AcQb5gmkrxTZLntDRPiASXDf33YtUA==
> | >| Newsgroups: microsoft.public.access.security
> | >| Path: cpmsftngxa06.phx.gbl
> | >| Xref: cpmsftngxa06.phx.gbl
> | microsoft.public.access.security:9737
> | >| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
> | >| X-Tomcat-NG: microsoft.public.access.security
> | >|
> | >| My administrator log in will not allow me to change
> | >| ownership of a report. All my reports are locked and
> | >| ownership is unknown, and there is no way to log into
> | >| unknown. And I can't find a way to turn security off
> | and
> | >| reset it. I have 4 months worth of work locked into
> | this
> | >| files. All my other selections (ie tables, macros,
> | >| queries) all work properly, just the reports tab. How
> | >| can I either drop ALL security or change ownership of
> | the
> | >| reports to admin?
> | >|
> | >
> | >.
> | >
> |
>

Loading