Search
  You are here: Tech Blog Register   Login  
Microsoft Access 2007 - Workgroup Security
Location: BlogsAll Things Tech    
Posted by: host 10/12/2006 4:40 PM
I've been developing a large application in Access for a number of years. Today I attempted to open it up in Access 2007 for the first time and got the security warning that I was not a member of the proper workgroup. In the past, you simply selected a menu option and joined the proper workgroup by pointing to your .MDW file. This feature appears to have been removed in '07.

But all is not lost. You can fire up regedit and update the following registry key:

HKCU\Software\Microsoft\Office\12.0\Access\Access Connectivity Engine\Engines\SystemDB

I copied my custom MDW file to the following folder in my profile:
"C:\Documents and Settings\%username%\application data\microsoft\Access"

and changed the registry key to "Application Data\Microsoft\Access\custom.mdw"

Simply restart '07 and open your MDB and you are in business!
Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 
 

Other things you might like...
 

All Things Tech... Mostly
 

Blog Search
 

All Things Tech... Mostly
 

Copyright 2007 by SummerWorks.us Terms Of Use Privacy Statement