A complex system that works is invariably found to have evolved from a simple system that worked. A complex system designed from scratch never works and cannot be patched up to make it work. You have to start over, beginning with a working simple system.
—
John Gall
What company would I want to own and why?
When traveling on business and living out of a hotel room, Touchfit: GSP is an excellent iPhone application for a fantastic 20, 40 or 60 minute body weight workout.
“The only person you are destined to become is the person you decide to be.” —Ralph Waldo Emerson
“The two most important days in your life are
the day you are born and the day you find out why.”
—Mark Twain: American author and humorist
While I have not used Microsoft Access for a long time (no serious work since Access 2.0 circa 1995), I can’t believe how the product has evolved. The Access 2013 interface is virtually unusable for simple data cleansing/mining tasks. I mistakenly thought Access would be right tool to take some Excel data, add some primary keys, remove duplicates, and make the data more relational (especially since I’m not an Excel guru). Unfortunately it’s now easier to use Microsoft SQL Enterprise Manager than Access 2013. It feels like in the desire to make Access ‘user friendly’ has morphed it into ‘user frustration.’
“Your habits become your values,
Your values become your destiny.”
—Mahatma Gandhi
If you receive this advice from Microsoft SQL Server: “You should correct this situation by resetting the owner of database ‘mydatabase’ using the ALTER AUTHORIZATION statement.”
I found the easiest solution is to actually drop the existing user account in the database and then change the owner to the server’s login account using the following commands:
use mydatabase
exec sp_dropuser "user_acct" — security user in the database
exec sp_changedbowner "user_acct" — security login in the server
My main PC, which was running Windows 8, failed. Rather than repair the Windows 8 OS, I reverted back to Windows 7—and the desktop experience is much better.
Just in case another fresh install is ever needed, below are the free software applications I install and recommend:
Recently I moved a hard drive from an older PC to a newer one. I attempted to delete the Windows and Program Files directories and was given this unfriendly message:
Folder Access Denied
Clicking continue fails with a message abut requiring permission from TrustedInstaller.
No need to Try Again, it won’t work.
To fix this dilemma one needs to edit the properties of the folder twice. Once to obtain ownership and secondarily to set full control permissions.
Start with right clicking on the folder from explorer and selecting properties:
and on the security tab click Advanced near the bottom.
Switch to the Owner tab and click Edit…
Highlight your user account in the Change owner to: section and click on Replace owner on subcontainers and objects as shown below:
Click Apply and wait for the Windows Security dialog changing ownership of to finish. Once finished you will be presented with this dialog:
Click OK and OK and OK and OK (4 times) to close out of the properties windows.
Next, right click on the folder again; select properties again; go to the security tab again and click Advanced again (like in the instructions above).
From the Permissions tab (shown below), click on Change Permissions…
Next is displayed the Advanced Security Settings dialog:
Click on Add… and fill out the Enter the object name to selected:
In the next dialog (Permission Entry) check Full control “Allow” as shown below. And you don’t want to check “Apply these permissions to objects and/or containers within this container only”.
After returning to the prior dialog and before clicking on Apply, make sure “Replace all child object permissions with inheritable permissions from this object” is checked as indicated below:
The last step is to click Apply and agree to the following warning:
With the changes applied, you can click OK, OK, OK to close out of the open dialogs.
And now the folder can now be deleted.