[AccessD] What a mess (otherwise knbown as "who owns things")

Heenan, Lambert Lambert.Heenan at aiuholdings.com
Tue Jun 2 07:56:03 CDT 2009


With Vista it seems that there is a 'Sharing' tab all the time. In folder options there is an option called 'Use Sharing Wizard (Recommended)', but just turns on/off the wizard for setting up Shares (not the same thing as setting security rights).

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 01, 2009 3:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] What a mess (otherwise knbown as "who owns things")

Thank you.

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: 01 June 2009 19:57
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] What a mess (otherwise knbown as "who owns things")

I will have to check on my Vista virtual machine when I get home. I know in Windows 7 the setting is pretty much the same as in XP.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 01, 2009 2:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] What a mess (otherwise knbown as "who owns things")

I will check that tomorrow at work on my XP.

Any idea of how to do it in Vist.  Folder Options doesn't have an Advanced Button or Tab.  Just, General, View and Search and cannot see anything similar.

Thanks

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: 01 June 2009 14:54
To: 'Access Developers discussion and problem solving'
Cc: Stalklinga, Asa at UNAT
Subject: Re: [AccessD] What a mess (otherwise knbown as "who owns things")

You probably have 'simplified file sharing' turned on (the default I think).
In Windows XP open an explorer window and select 'Folder options' on the 'Tools' menu.

Then select the 'View' tab and scroll down to the bottom of the list in the 'Advanced Settings' area. There you will find the 'Use simple file sharing (Recommended)'  option. Clear the check box, and then reboot.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Monday, June 01, 2009 9:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] What a mess (otherwise knbown as "who owns things")

No Security Tab on my PCs Lambert.

I get

General, Tools, Hardware, Sharing, Quota

Max


On 6/1/09, Heenan, Lambert <Lambert.Heenan at aiuholdings.com> wrote:
>
> Right-click the C drive and select properties, and then hit the
> Security tab.
>
> Make sure that 'Administrators' is listed and that they have 'Full
Control'
> access. Add any other users you might want at this point too.
>
> Next click the 'Advanced' button and I the new dialog box click the
'Owner'
> tab. Change the owner to the Administrators group and check the box to
> 'Replace owner on subcontainters and objects'.
>
> Click the 'Permissions' tab of the same dialog box.  Check the box to
> 'Replace permission entries on all child objects..."
>
> Click OK and sit back and wait.
>
> Should sort things out for you.
>
> HTH
>
>
> Lambert
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Sunday, May 31, 2009 11:07 PM
> To: Dba-Sqlserver; Access Developers discussion and problem solving
> Subject: [AccessD] What a mess (otherwise knbown as "who owns things")
>
> I rebuilt a server from C:\ format on up.  New Windows Server 2003
> X64, New SQL Server 2005 etc.
>
> Now the current administrator (apparently) does not own the files on
> the raid arrays which of course survive quite nicely.  When I tried to
> attach a database it gave me an "insufficient rights" kind of error
> which I Googled and that tells me that I do not own the files.  I took
> ownership which worked (I can now attach),  but then I tried to attach
> and it said it couldn't because the files were read only.
>
> Only it DID the attach, and now I have a database in read only mode,
> which I cannot detach because... it is read only.
>
> Sigh.
>
> So... this invites MANY questions...
>
> 1) How do I take ownership of a disk drive on down and all the files
> on that disk drive?
> 2) Why are the files read only?
> 3) Now that I have one of the databases mounted (read only) how do I
> detach it so that I can make it read / write and reattach it?  Or how
> do I make it non-readonly?
>
> 4)Why did all of this happen?
> 5) Is there an easy way to prevent all this in the future?  I have a
> second server which I will be rebuilding when new parts get here mid
> week.  New motherboard / processor and 5 new terabyte drives for the
> server I rebuilt this weekend and 5 new drives for the one to be
> rebuilt next.  Obviously if there is something I can do in advance to
> prevent this mess I am all for that.
>
> In fact the new motherboard is the same motherboard as I have in the
> current rebuild, and my plan is to clone the boot drive and just use
> that clone in the new system.  I have gone to much trouble to get all
> the multitude of software installed etc so when I am done I HOPE to
> end up with two literally identical machines, other than the second
> machine having some additional storage (and a next generation processor).
>
> Any words of wisdom out there?
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list