Show All

Create an Access user profile

Caution   Incorrectly editing the registry may severely damage your operating system, requiring you to reinstall it. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For the most recent information about using and protecting your computer's registry, see Microsoft Windows Help.

1. Start the Registry Editor

   How?

   1. Click the Microsoft Windows Start button.
   2. Click Run.
   3. Type regedit.
   4. Click OK.
2. Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE subkey.
3. Add three nested subkeys by using the following format to ensure uniqueness: \Your Company\Your Application\Your Application Version Number.
4. Under the \Your Application Version Number subkey, re-create any of the subkeys located under the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access subkey that contain values that you want to modify (except the \Profiles subkey, which you will create in step 7), and then copy the appropriate values under each subkey.
5. Modify the values that you want to change.
6. Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access subkey.
7. Add a new subkey, and name it \Profiles.
8. Add a string value to the \Profiles subkey, and give it the name that you want to use on the command line.
9. For the value's data, enter a string that points to the location of the subkeys you created in step 3: SOFTWARE\Your Company\Your Application\Your Application Version Number
10. Create a command line for your application that specifies the name you entered in step 8, and enclose the name in double quotation marks ("). For example: MSAccess.exe /profile "Your Profile" "Your Application.mdb"

Override any of the Microsoft Jet 4.0 database engine default settings for Access

1. Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Your Company\Your Application\Your Application Version Number profile subkey.
2. Create a subkey named \Jet\4.0\Engines.

3. For the first default setting you want to override, add an appropriately named subkey below the subkey created in step 2. For example, to override Jet Paradox settings, add a subkey named Paradox.

4. Add values of the appropriate name and type to that subkey, and then specify the settings.

   You can model your subkeys and values after the subkeys and values in \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines.

5. Repeat steps 3 and 4 for each default setting you want to override.

Note  In a Microsoft Access database or Microsoft Access project, it's possible to have the same registry key set in three different ways; but only one value can be used. In a case like this, an Access user profile setting takes precedence over an Access database or Access project setting, which in turn takes precedence over a Microsoft Jet setting.