Archive for the ‘Knowledge Base’ Category
Thursday, June 25th, 2009
File sharing lock count exceeded (Error 3052).
The error may also occur when you run a Visual Basic for Applications procedure that uses the Synchronize method.
A member of the replica set contains too many changes for synchronization to be completed successfully. For example, if one of the replicas has increased in size by 100 megabytes (MB) because you have added a large number of new records, you may receive this error. The replica that contains too many changes may be the database from which you are attempting to synchronize, or it may also be another member of the replica set.
If you are using Microsoft Access 97, you can take advantage of a new feature that allows you to increase the MaxLocksPerFile setting for Microsoft Jet database engine 3.5 by editing the Windows Registry. The default value of this setting is 9500. However, changing this value is not recommended if one of the replicas is located on a Novell Netware server because the server’s maximum record locks per connection is 10000. In addition, changing this value will result in poor performance if one of the replicas is located on a server running Windows NT version 3.51 or earlier. If both replicas are located on servers running Microsoft Windows NT version 4.0 or Microsoft Windows 95, the maximum value of this setting is limited only by available resources.Â
WARNING: Modifications made to the system registry are considered advanced usage of the Windows 95 or Windows NT operating systems. Extreme care should be taken when making modifications. Any invalid or incorrect entries may render the operating system unusable.Â
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.Â
For information about how to edit the registry, view the Changing Keys And Values Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.Â
- Quit Microsoft Access.
- Click the Start button, and then click Run.
- In the Open box, type regedit.
- Locate the HKEY_LOCAL_MACHINE registry folder.
- Expand the HKEY_LOCAL_MACHINE folder until you locate the folder SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5.
- Double-click the Jet 3.5 folder to view its contents.
- Select the MaxLocksPerFile entry; on the Edit menu, click Modify.
- In the Edit DWORD Value dialog box, select Decimal and increase the number in the Value Data box.
- Click OK to save the MaxLocksPerFile setting.
- Quit the Registry Editor.
- Start Microsoft Access and synchronize the replicas.
Tags: Access 97, File Sharing Lock Count, Record locks
Posted in Knowledge Base | Comments Off
Thursday, January 22nd, 2009
This error is easily fixed by installing XP SP3 on your workstation.
Tags: Error, Object, Substruct, XP
Posted in Knowledge Base, Substruct, Substruct Utilities, Troubleshoot | Comments Off
Tuesday, January 13th, 2009
Problem
When trying to run Substruct Utiilities (substruct.exe) over the network for the first time, you may receive an error:
The application failed to initialize properly (oxc0000135). Click on OK to terminate the application.
This is due to the Microsoft .NET Framework Runtime Security Policy no being configured correctly.
Solution
On a Windows XP computer, do the following:
1. Open Control Panel.
2. Open Administrative Tools.
3. Open Microsoft .NET Framework 1.1 Configuration.
4. Expand Runtime Security Policy.
5. Expand Machine.
6. Expand Code Groups.
7. Right-click on All_Code and click Properties.
8. Click the Permission Set tab.
9. Change the Permission Set drop down to “Full Trust”.
10. Click OK to save this change.
11. Close the .NET Configuration 1.1 window.
Tags: .NET, application failed to initialize properly, Substruct, substruct.exe
Posted in Knowledge Base, Substruct, Substruct Utilities, Troubleshoot | Comments Off
Monday, January 12th, 2009
To make your Handheld (Honeywell) 3800g barcode scanner stay on all the time (great for when inside a craddle or stand), scan the “Automatic Trigger” barcode bellow.

Tags: 3800g, automatic trigger, barcode, Handheld, honeywell, manual trigger, presentation mode, scan, scanner
Posted in Knowledge Base, Point of Sale | Comments Off
Saturday, January 10th, 2009
This problem is due to items being scanned too quickly in Cougar Mountain. To prevent this, adjust the “Reread” and “Good Read” delays on your barcode scanner. For the Handheld 3800g (Substruct’s recommend barcode imaging device) print or scan the barcode bellow. “Medium” speed is recommended for both.


Tags: 3800, 3800g, barcode, Cash out, close out, Drawer, Handheld, Open, Point of Sale, POS, scanner
Posted in Cougar Mountain, Knowledge Base, Point of Sale, Troubleshoot | Comments Off
Wednesday, September 3rd, 2008
Occasionally, Accounts Receivable total will be off. This is caused by Cougar Mountain for unknown reasons. To check for discrepancies, do the following:
- In AR, go to Reports > Control. Click OK to run the report.
If their are errors or discrepancies, do the following:
- In AR, go to Options > File Maintenance > Recalculate Master File…
- From here you can either enter in the customer’s account number, or rebuild the totals for every customer. It is recommended that you do this when you are closed and not using Cougar Mountain on other computers.
Â
Tags: Accounts Receivable, AR, Cougar Mountain
Posted in Accounts Receivable, Cougar Mountain, Troubleshoot | Comments Off
Thursday, August 28th, 2008
Short barcodes on some merchandise may not scan correctly by default. These barcodes use the UPCE (usually UPCE0) symbology, and most aliases are stored in your Cougar Mountain installation in the standard 12 digit UPCA format. For reference, Ace sends down UPC information in UPCA format. To enable your scanner to convert UPCE to UPCA, do the following:
Symbol MC50 or MC9000 handheld scanners
- From the Start screen, click on Scan Wedge in the bottom right hand corner of the home screen.
- Click Config
- Click Codes
- Make sure UPCE0 is checked
- Highlight UPCE0 and click ParamÂ
- Click Cnvt to UPCA to switch the value to True.
Handheld Products (or Honeywell) 3800G
Print and scan the following “On” barcode.

Â
Â
�
Tags: barcode, scan, scanner, UPCA, UPCE, UPCE0
Posted in Knowledge Base, Symbol, Troubleshoot | Comments Off
Thursday, August 28th, 2008
The Tools menu contains links to the Signs and Labels programs, both of which can also be found on the Switchboard. It also has a links to the Customer Rewards utility, the Barcode Generator, and the Register Item Sheet tool.
Posted in Tools | Comments Off
Tuesday, August 26th, 2008
The .cpf font files need to be loaded on to the printer using Zebra’s Label Vista software. Contact technical support for assistance with this.
Tags: Label Vista, Labels, QL320
Posted in Knowledge Base, Substruct, Substruct Mobile, Zebra | Comments Off
Friday, August 15th, 2008
The Zebra QL320 must be configured with a serial cable (to order one, give us a call).
Then the Label Vista must be downloaded from Zebra’s website (www.zebra.com) and installed on the computer you are using to setup the printer.
We recommend that you use some for of wireless encryption. WPA is more secure than WEP, and it also makes setting up laptops and other mobile devices easier (just give the user the pass phrase).
Setup your router’s wireless network
For a Linksys wireless router such as the WRT54G (or most wireless routers for that matter) you will need to set the following:
- SSID: The name of your wireless network (i.e. AceHardware, SmallTownHardware, etc.)
- Set the security to WPA Personal.
- Set the WPA Algorithms to TKIP.
- Set the WPA shared key to an 8 character password of your choice (i.e. ace54321, 1337pass).

 Configure your QL320 printer with Label Vista
- Plug in your printer.
- Make sure Label Vista is set to use the correct Com port.
- Go to Printer > Network Settings.
- Fill in your network settings. Make sure you set the IP address to be the same as it is in Substruct Utilities preferences (usually 192.168.X.100)

-
Next, configure the WPA security.
-
Set the Mode to WPA
-
Set Authentication to PSK
-
Set PSK to Ascii and then enter you pass phrase.
-
Click OK or Apply to send the changes to the printer.

Tags: Label Vista, Labels, QL320, Substruct Mobile, Wireless, WPA, Zebra
Posted in Zebra | Comments Off