Why is it always complicated?

I recently upgraded to Office 07 at work. The headache was a hassel only because microsoft decided to try to correct the Microsoft Access security model. In previous versions you would run the Work Group Administrator to join a workgroup by selecting the workgroup information file. This worked just fine for me as a regular user did not have enough permissions to join another workgroup. I embed the following VB Code in the openning switchboard to make sure that have the access client set up to launch a switchboard form on startup and make use some embedded VB Code

' Verify the current user is not Admin
If CurrentUser = "Admin" Then
Msg = "Network or Workgroup error."
MsgBox Prompt:=Msg
CloseCurrentDatabase
End If

Anyways, now there is no shortcut to the Workgroup Administrator. It isn't even anywhere on the system menu! The only way i've found to get to it is to call it through visual basic (as noted KB Article 888734).

  1. In Access 2007, open a trusted database, or enable macros in the existing database.

  2. Press CTRL+G to open the Immediate window.

  3. Type the following line of code, and then press ENTER.
    DoCmd.RunCommand acCmdWorkgroupAdministrator

  4. In the Workgroup Administrator dialog box, click Join, and then click Browse.

  5. Locate and then click the following file, and then click Open:
    C:Program FilesCommon FilessystemSystem.mdw

  6. In the Workgroup Administrator dialog box, click OK, and then click Exit.


they have needlessly complicated something that was working just fine.

if (NewVersion > OldVersion)
needlessComplication++ ;

Comments

Popular Posts