ACC2000: Error Starting Microsoft Access with Custom Profile

1. The workgroup file is not located in the same folder as Msaccess.exe.
2. The shortcut that you are using to start Microsoft Access does not contain a /Wrkgrp switch that points to a valid workgroup file.
3. The custom profile that you are using does not contain a Jet subkey that points to a valid workgroup file.

1. On the Start menu, click Run.
2. In the Run box, type Regedt32, and then click OK.
3. In Registry Editor, locate the following registry key:
   HKEY_CLASSES_ROOT\TypeLib\{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}\9.0
4. On the Security menu, click Permissions.
5. In the Permissions for 9.0 dialog box, under Security, locate the Everyone and the TERMINAL SERVER USER groups and verify that both of them have full control.
   
   Note If the Everyone and the TERMINAL SERVER USER groups do not exist , add both the groups, and then provide them full control.
6. Click OK, and then exit the Registry Editor.

Use the /Wrkgrp Switch to Specify a Workgroup File

   "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /Wrkgrp  "C:\MyApplication\System.mdw" /Profile Test
				

Include a Jet Subkey in Your Custom Profile

1. Create a custom profile and a shortcut by following the steps in the "Creating a Custom Profile to Use with Microsoft Access" section later in this article.
2. In Registry Editor, locate the following key:

      HKEY_LOCAL_MACHINE\Software\Test\MyApp\1.0   
   					

3. Create the following subkeys

      Jet\4.0\Engines
   						

   to create the following key:

      HKEY_LOCAL_MACHINE\Software\Test\MyApp\1.0\Jet\4.0\Engines
   					

4. Under the subkey Engines, create the following string value:

      SystemDB
   					

5. Set the value of the SystemDB string value to the path of your workgroup file, for example, C:\Workgroup\System.mdw

Creating a Custom Profile to Use with Microsoft Access

1. Click Start, and then click Run.
2. In the Run box, type Regedit, and then click OK.
3. In Registry Editor, expand the following key:

      HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Access\Profiles
   						

   NOTE: If the Profiles key is not listed under the Access key, you must create it. To create the Profiles key, right-click the Access key, point to New, and then click Key. Rename the new key to Profiles.
4. After you click the Profiles key in the left pane, right-click in the right pane, point to New, and then click String Value.
5. Under the Profiles key, create a new string value named Test.
6. Set the value of the Test string value to Software\Test\MyApp\1.0.
7. Locate the following registry key:

      HKEY_LOCAL_MACHINE\Software
   					

8. Create the following subkeys

      Test\MyApp\1.0\Run-Time Options
   						

   to create the following key:

      HKEY_LOCAL_MACHINE\Software\Test\MyApp\1.0\Run-Time Options
   					

9. Under the subkey Run-Time Options, create the following string value:

      TitleBar
   					

10. Set the value of the TitleBar string value to My Application.
11. Quit Registry Editor.
12. On the desktop, create a shortcut with the following command line.
    
    NOTE: The path to Msaccess.exe may be different on your computer. Make sure the path in your shortcut accurately reflects the location of Msaccess.exe on your computer.

       "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /Profile Test
    					

Steps to Reproduce the Behavior

1. Create a new folder on your computer named C:\Workgroup.
2. Move your current workgroup file (System.mdw) from its current location to the C:\Workgroup folder. If you do not know the current location of your current workgroup file, you can use the Workgroup Administrator (Wrkgadm.exe) utility to locate it.
3. After moving the workgroup file, use the Workgroup Administrator utility to rejoin the workgroup.
4. Start Microsoft Access, and then open any database (.mdb) file to verify that Access is functioning correctly.
5. Quit Microsoft Access.
6. Create a custom profile and a shortcut by following the steps in the "Creating a Custom Profile to Use with Microsoft Access" section earlier in this article.
7. Double-click the shortcut to start Microsoft Access. Note that Microsoft Access starts with "My Application" in the titlebar.
8. Open any database (.mdb) file.