hotfix MS Access performance windows 7

New hotfix solves Access 2010 performance issue

Thanks to Tony Toews and his blog for bringing this to our attention.

Access 2010 hotfix package (Ace-x-none.msp): August 30, 2011  which can download from here by request.

This solves the Access 2010 nd Windows 7 performance issue.

As with all hotfixes, only apply if you really has having an issue described and you can’t live with it until the next Service Pack is released.

backup operators backuppc Domain SAMBA windows 7

Backuppc+Samba and Backup Operators confusion

I have been using the excellent backup server Backuppc and if you need a network backup facility which can backup Windows, Unix and Linux systems give it a look.

It does have one flaw in it however and this may catch you out if you get confused by the Backup Operators group.

On every Windows machine there is a group called Backup Operators which if look at the description says:

Backup Operators can override security restrictions for the sole purpose of backing up or restoring files

So you think to yourself, “Great I can put the backuppc user into that group on the Samba PDC and I’ll be able to backup all the files I want”.

Unfortunately it does not work out that way, for two reasons:

  1. The domain Backup Operators can only be used on domain controllers.
  2. Backuppc uses smbclient to connect and not Windows Backup API.

A look on technet explains the privileges the Backup Operator group has. So putting the backuppc user into the domain Backup Operators group does not give it privileges to backup all the PCs.

And putting the backuppc user into the Backup Operators group will not solve the problem either because of no. 2. Samba’s smbclient will login as a normal user and the OS will use the file system ACLs to determine rights. Those rights to read all files regardless of the ACL permissions applies only when the Windows Backup API is being used.

So you have two choices really.

  • Add  read, traverse, list folder contents for the Backup Operators group to the files and folders you want the backup to read. And place the backuppc user into the Backup Operators group on the PC.
  • Use the administrator account

The first choice is obviously very tedious and error prone and the second choice has some security risks with it. I chose the latter and I suspect most users will too.

I have read something about Zmanada’s Windows Client for Amanda but I’m not sure if it uses the Backup API or not and would solve this problem. It is something for me to look into.

apache sp1 webdav windows 7

Webdav "improvements" in Win7 SP1

I previously wrote about the problems I have had using webdav in Windows 7 to my webdav server. If you haven’t read it follow this link.

Essentialy using the Window 7 webDAV client to a server using basic authentication over SSL did not work. No matter how hard you tried.

This situation has only been slight rectified in Win7 SP1, but with other issues. When I tried to create the drive mapping to the server I get some real weirdness.

  1. When the mapping is created I get an error that the mapping already exists, which is very weird. A look under My Computer reveals three identical links have been created.
  2. Using one of the links does connect to the server and I can see the folders and files. But I cannot navigate through the folders, nor can I open and of the files! Which makes it quite useless.

I have attempted to look for a solution to this issue, but nothing has turned up so. Its entirely possible that I’m the only one encountering this problem. For the moment I’ll still keep using the 3rd party client I have been using for the past year.

Anyone with a solution please feel free to comment.