Unable to open registry key on export

Updated 2009-12-01 | Filed under OnWeb | PDF

Problem

When exporting data, I get this message in the lower left-hand corner: 

EQL Data: Result: export: connect: SQLHY000: General error Unable to
open registry key Temporary (volatile) Ace DSN for process
0x<something> Thread 0x<something else> DBC
0x<even yet something else>

I can't synchronize! Help!

Solution

This error has been known to occur on Access 2007 installations in Windows Vista, and stems from your Windows user not having write-access to the ODBC registry components.

To solve this, you will need to know your Windows username, and have Administrator privileges. To obtain your Windows username, please go to your Control Panel, and click 'User Accounts and Family Safety', then 'User Accounts'. The right-hand display should show your login icon, your username (in large font), and whether you are an Administrator (it will say 'Administrator' under the user name). If you do not have Administrator privileges, please contact an administrator to perform the following steps for you.

  1. Open up your registry editor. Do this by clicking on the Start Menu logo on the bottom left-hand side of the screen, and then typing 'regedit' in the text box on the bottom of the Start Menu, as indicated:

    Start Menu | Regedit

    Your Start Menu will change to show a list of Programs matching 'regedit', and you'll see 'regedit.exe' as the top hit. Click this. A new window comes up:

    Regedit Open

  2. In this Registry Editor window, navigate (using the explorer-style left-hand bar) to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC. Right click on this last component (ODBC) as shown:

    Regedit: HKLM/Software/ODBC Right-clicked

  3. Click 'Permissions...'. In the new window that comes up, click 'Add', which will spawn yet another window. Here, enter the Windows username you ascertained above in the white text text box provided, as shown:

    Select Users or Groups

  4. Click 'Check Names', which will either bring up a new dialog suggesting that you've mistyped the name, or accept your username. Once that's done, click 'OK'to return to the main permissions screen. Here, make sure that for the user you just added (shown below highlighted in blue), you set the user permissions to 'Full Control', as well as 'Read' then click 'OK', as shown:

    Permissions for ODBC

  5. You should be able to close the registry editor now, and attempt your Synchronization again without further issue.

If you have difficulties with the above procedure or experience further problems, please contact support@eqldata.com, and we'll be happy to help you resolve any issues as soon as possible.

Related Articles

Unrelated Articles