Access user profile

  • Thread starter Michael Breitsameter
  • Start date
M

Michael Breitsameter

For an acc2000 - application I've tried to create an Access user profile as
it is described in help.
I've performed each step exactly, but Access always prompted the message:
"The profile 'xy' that you are using in the command does not exist in the
windows-registry".
For the command line I used double quotation marks for the profilename and
the filename.
Under \HKEY_LOCAL_MACHINE\Software\ I added a subkey
\company\application\versionnr.
And under \HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\Access\ I added
the required subkey \Profiles. Under this subkey I added a Stringvalue which
has the name I'am using in the commandline and a value, that refers to the
subkey \HKEY_LOCAL_MACHINE\Software\company\application\versionnr
But the result is always the same.


Michael Breitsameter
 
A

Arvin Meyer

I'm not sure what you are trying to do (or why), but one thing I see that
may be a problem is version. You state you are using Access 2000, but the
key is for Office 10.0, which is Access 2002. The error you are getting is
consistent with a mismatch of versions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
M

Michael Breitsameter

The reason why I try to create an user profile is that I need special
settings for the application such as Run Time Options like the applications
icon or to associate a custom help file with a database. In this case it is
recommended to create a user profile because the Access-settings e.g. for
the Jet-engine are valid for all projects running under Access. I'am using
Access 2002. But the mdb-file is Access 2000. If I start Access with a
command line like this:
MSAccess.exe /profile "myprofile" "mydb.mdb"
and there is under the subkey /Office/10.0 no subkey /Profiles
Access creates itself an empty subkey /Profiles and than the error appears
"The profile 'myprofile' that you are using in the command does not exist in
the windows-registry", though I ' ve already created reference for the
Profile "myprofile" as it is described in the Access - help. What goes
wrong?

Here the english version of the microsoft - article which describes the
task:

First you need to create a new Access user profile
***********
Create an Access user profile
Start the Registry Editor
How?

Click the Microsoft Windows Start button.
Click Run.
Type regedit.
Click OK.
Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE subkey.
Add three nested subkeys by using the following format to ensure uniqueness:
\Your Company\Your Application\Your Application Version Number.
Under the \Your Application Version Number subkey, re-create any of the
subkeys located under the
\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.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.
Modify the values that you want to change.
Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Access
subkey.
Add a new subkey, and name it \Profiles.
Add a string value to the \Profiles subkey, and give it the name that you
want to use on the command line.
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
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
Navigate to the \HKEY_LOCAL_MACHINE\SOFTWARE\Your Company\Your
Application\Your Application Version Number profile subkey.
Create a subkey named \Jet\4.0\Engines.
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.

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.

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.
***********
 
D

david epsom dot com dot au

This is a profile string value:

SOFTWARE\Capix Treasury Systems Pty Ltd\CTM\8.6

Note that it does not include HKEY, and does not start with a slash.

(Also, FWIW, note that you should always NOT use the "Access Runtime"
key for profiles).

(david)
 
M

Michael Breitsameter

Thank you, so far the problem is solved.
But I've another one: if I use a commandline like this:

MSaccess.exe /profile "mypofile" "path\myApp.mdb"

Access returns the message:
Microsoft Access could not find the file "c:\progr~1\Micros~1\Office10\".
The file is required to start up.

If I start with /profile "myProfile" without "path\myApp.mdb" no error -
Message is returned.

(michael)
 
M

Michael Breitsameter

Thank you, so far the problem is solved.
But I've another one: if I use a commandline like this:

MSaccess.exe /profile "mypofile" "path\myApp.mdb"

Access returns the message:
Microsoft Access could not find the file "c:\progr~1\Micros~1\Office10\".
The file is required to start up.

If I start with /profile "myProfile" without "path\myApp.mdb" no error -
Message is returned.

(michael)
 
D

david epsom dot com dot au

Our command line looks like:
"c:\program files\ ... \msaccess.exe" "path\myapp" /profile myProfile

I don't recognise the error message you are getting,
but I wonder if you need to look at the SystemDB setting
in your profile ?????

(david)
 
M

Michael Breitsameter

I wonder if you wonder that I need to look at registry setting a special
profile for the start-up conditions for an
access application. Look at the access help, type the key word "profile".
You will get 3 results:
1. Set up a an access userprofile
2. Define the access run time options (with registry)
3. Informations to adjust the applications background with userprofiles and
run time options.

Only for the jet-settings there is an alternative method with the DAO.
Microsoft itself recommends to use a registry profile to avoid interactions
of the own access application and other access applications. Such a profile
is only valueable using the command line. There is a SysCmd- methode to
check at runtime wether the application was started with the correct
profile.

But why does it not function properly? What is the secret with the command
line?
 
Top