an ms office programming experience

The last few days were very busy. I’ve learned more about the internals of MS Access’ security model than I ever cared, or thought, to. My goal was to create a report detailing the security permissions graned each user and group within a secured database. At first I decided to use MS Word to write the report, big mistake! After letting the report run for 1.5 hours (it only takes 45 seconds to actually retrieve the permissions) I decided to kill it.

A bit of testing (removing the display of the permissions) revealed a monster report of 415 pages, listing the users, containers and documents. Adding the 10-15 permissions each document has explains why MS Word bombed. It’s never worked well for me with large documents.

Switching to MS Excel worked. The report looks much better and it only takes 1.5 minutes to create the report. Very nice. It’s still large, at 520 pages, but it is by all means complete. It makes me wish I could see the look on the Corp auditors face when she opens the report

Related posts

1. Searching MS Office Documents From the DocIndexer webpage: DocIndexer is a toolkit for indexing...
2. The Art of Programming Charles Miller presents a very convincing argument regarding the Art...
3. MS Technical documentation strikes again! This is an oddity I’ve encountered in the past....
4. Principles of Programming Though this is slanted toward Java developers, certainly the pratical...
5. Securing PHP in Shared Hosting Environment One of the problems inherent to using an Apache Module...

Related posts brought to you by Yet Another Related Posts Plugin.