AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, August 16, 2005

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

2 Comments:

Anonymous Anonymous said...

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

12:08 PM  
Blogger Alex Dybenko said...

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

12:58 PM  

Post a Comment

Links to this post:

Create a Link

<< Home