Tuesday, February 21, 2006

Access 2007 - Depreciated Workgroup Security

In the next version of Access, the much cursed, the difficult to understand but quite detailed security system that is known as User Level Security (workgroup security) is not going to be supported by the next version of the Microsoft Jet engine. The way that it is going to be phased out is as follows.

Access will support Access 2000-2003 databases (mdb, mde, and mda) in a similar manner to what you are used to.

If you or your users upgrades your databases to a new file format called a ACEDB format, workgroup security will not be supported. This means in reality that you will then need to rely on personal protection systems for your security. If you are a reader of my book on Access protection and security, this means that you will only be able to draw on Chapters 1-6 and Chapter 12 for information if your database gets upgraded to the ACEDB format.

The good news though is that you have removed ownership from the Admin account for any object in the database, your users will need Administrator workgroup accounts and passwords to upgrade the database to the ACEDB format and you will be left with managing the MDB in much the same manner. In this situation Chapters 7, 8, 10 do apply and arguably are more important. Of course when Access 2009/2010 rocks along, this may change and you may be forced to upgrade. Of course the new features in Access at this time may also encourage you to upgrade.

To counteract the developer protests on removing workgroup security, Microsoft have beefed up the database password so that it is not stored in the database and invented a way that macro security warnings can be turned off if a database is stored in nominated folder.

Please sign up for Beta 2 if you feel that this depreciated feature is going to affect your database going forward. Remember if you do so, please use a spare computer or an empty boot operating system for your testing. As I am a Beta 1 participant, I cannot make my views on this depreciated feature topic known.

To view the chapters in my book, head to read the table of contents in PDF format or head to a page describing the book at vb123.com.

What are your thoughts on User Level Security getting squished...