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

From: Eric Butts [MSFT] (ebutts_at_online.microsoft.com)
Date: 04/07/04 

Date: Wed, 07 Apr 2004 19:17:03 GMT

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?
| >|
| >
| >.
| >
|