Import/export in Access while running with /Profile
If you start your Access application with /Profile startup option, and in your application you are using Import/Export facilities - you have to add few keys in registry in order to have Import/Export working.
- First you have to look in registry under
HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Office\ 11.0\ Access\ Jet\ 4.0\ ISAM Formats
Find a subkey which you want to add to your profile, for example Excel 8.0
Export desired subkey to a text (*.reg) file - Modify this text file so the path of the key will be:
HKEY_LOCAL_MACHINE\ SOFTWARE\ $COMPANY$\ $PRODUCT$\ Jet\ 4.0\ ISAM Formats\ Excel 8.0
Where
HKEY_LOCAL_MACHINE\ SOFTWARE\ $COMPANY$\ $PRODUCT$ is a location of your profile - Add information from modified reg file to your registry
Actually same applies to Report Formats and Clipboard formats options
posted by Alex Dybenko | 13:13
Copyright © 2016 Alex Dybenko
2 Comments:
In your post, you have mentioned the Access application with /Profile startup option.
Could you advise how I determine if this is the case?
I have a client who is suffering this problem and it seems that the only suggested options for the fix are to ensure a correct filename (done that) and to alter the registry settings for this "profile". To be able to walk the client through what needs to be done will save a trip to the other end of the country, so would greatly appeciate any help that you could offer.
Sean
sean[at]fullingdale[dot]com
Hi,
to see what profile used to start access you can use:
syscmd(acSysCmdProfile)
if he really runs access using profile - you have to modify registry settings like described here
Post a Comment
<< Home