Agree!! Taking that the obvious was already checked.... there's tons of
cases where they are joining to correct MDW file however the owner shows as
Unknown.
Eric
--------------------
| From: "TC" <
[email protected]>
| Newsgroups: microsoft.public.access.security
| References: <
[email protected]>
<
[email protected]>
<
[email protected]>
<
[email protected]>
| Subject: Re: how do I change ownership of and "unknown" owner
| Date: Thu, 8 Apr 2004 13:06:05 +0930
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <
[email protected]>
| Organization: Chariot Internet -
http://www.chariot.net.au
| X-Original-NNTP-Posting-Host: 127.0.0.1
| Lines: 155
| NNTP-Posting-Host: 203.87.95.150
| X-Trace: 1081395229 lon-reader.news.telstra.net 56489 203.87.95.150
| Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGXA0
1.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfe
eds.ihug.co.nz!ihug.co.nz!ken-transit.news.telstra.net!news.telstra.net!lon-
spool.news.telstra.net!203.14.2.27.MISMATCH!reader.news.telstra.net!not-for-
mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9798
| X-Tomcat-NG: microsoft.public.access.security
|
| 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
|
|
| | > 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
| > (e-mail address removed)
| > "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" <
[email protected]>
| > | Sender: "Chris" <
[email protected]>
| > | References: <
[email protected]>
| > <
[email protected]>
| > | Subject: RE: how do I change ownership of and "unknown" owner
| > | Date: Wed, 7 Apr 2004 06:52:16 -0700
| > | Lines: 89
| > | Message-ID: <
[email protected]>
| > | 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
| > | >
[email protected]
| > | >"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" <
[email protected]>
| > | >| Sender: "Chris" <
[email protected]>
| > | >| Subject: how do I change ownership of and "unknown"
| > | owner
| > | >| Date: Tue, 6 Apr 2004 07:47:09 -0700
| > | >| Lines: 9
| > | >| Message-ID: <
[email protected]>
| > | >| 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?
| > | >|
| > | >
| > | >.
| > | >
| > |
| >
|
|
|
