Search code examples
ms-accessvbamdw

Identify the workgroup MDW

In Microsoft Access, can you have Visual Basic identify what Workgroup you are using?

I find that new profiles need to be linked to the existing workgroup. Sometimes if the server crashes, Access doesn't find the workgroup and resets to the local workgroup.

Solution

  • The DAO.DBEngine object provides SystemDB property. You can retrieve the value of that property from VBA. Here's an example from the Immediate window.

    ? SystemDB
C:\Users\hans\AppData\Roaming\Microsoft\Access\System.mdw