My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Application Issues

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Useful Thread? Display Modes
  #1  
Old 03-Feb-2015, 04:14 PM
G.W.Green G.W.Green is offline
Administrator
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 480
Thanks: 0
Thanked 66 Times in 42 Posts
Software Hangs on Opening – Switching to the MS ACE Engine

SellerDeck v12.0.5 OHXC onwards

By default SellerDeck uses the MS Jet 4.0 database engine for Access. However this has a known bug which in some circumstances can cause SellerDeck to hang for a long period when opening a site.

If you experience this issue, it can be resolved in SellerDeck versions from v12.0.5 OHXC by switching to the more recent Microsoft Access (or ‘ACE’) Engine.

Unlike the Jet engine this is not a part of the Windows operating system. It is installed with Microsoft Access or the free Access Runtimes. To ensure you have a suitable version of ACE installed refer to How do I install a supported version of MS Access Driver?

To determine whether the ACE Engine is already installed and running on your system, take the following steps:
Windows 7 32-bit, Windows 8.0 and Windows 8.1:
  • Open the Control Panel and select ‘System and Security’, then ‘Administrative Tools’.
  • Double-click open ‘Data Sources (ODBC)‘.
Windows 7 64-bit:
  • Click the ‘Start’ button and paste the following text into the Search box:

    %systemdrive%\Windows\SysWoW64\Odbcad32.exe

    Entries for the Jet driver are labelled ‘Microsoft Access Driver (*.mdb)’. If there is at least one item labelled ‘Microsoft Access Driver (*.mdb, *.accdb)’ then the ACE driver is present. If there is no such entry then ACE is either not installed or not enabled.



To enable SellerDeck to use the ACE Engine, proceed as follows:

  1. Click the Windows ‘Start’ button. Type ‘regedit’ into the search box and press the Enter / Return key.
  2. Find and expand ‘HKEY_LOCAL_MACHINE’ and ‘SOFTWARE’.



  3. Find and expand ‘SellerDeck’ and then ‘2014’ (or whichever version you are using). If your Windows operating system is 64-bit, this will be within the ‘Wow6432Node’ hive.
  4. Right-click ‘2014’ and select New | DWORD (32-bit) Value.



  5. Enter the name ‘UseACEODBC’.



  6. Double-click the new entry and enter a value of 1.



  7. Click ‘OK’, then [X] to close the Registry Editor.
  8. Open SellerDeck.

Re-open the ODBC Data Source Administrator (above) and check the entries for SellerDeckCatalog14 and ActinicSimpeShipping14. They should now be tagged ‘Microsoft Access Driver (*.mdb, *.accdb)’ instead of ‘Microsoft Access Driver (*.mdb)’.
Attached Images
File Type: png ACEDR.png (39.6 KB, 484 views)
File Type: png ACEDR2.png (43.7 KB, 511 views)
File Type: png ACEDR3.png (31.4 KB, 485 views)
File Type: png ACEDR4.png (4.9 KB, 490 views)
File Type: png ACEDR5.png (13.6 KB, 494 views)
File Type: png ODBCDrivers.png (33.5 KB, 150 views)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.