Saturday, May 03, 2008

F1 help key does not work after workstation setup

After doing a workstation setup, the F1 help key does not work. You get a 'Cannot display page' error message. To rectify this, create a reg file (e.g. F1Help.reg) and enter the following:
Windows Registry Editor Version 5.00

Please make sure that the number of backslash '\' is correct and the UNC path is correct. Save the file and copy to where Accpac is installed in the server. This reg file needs to be registered in the server and every workstation client PCs.

As with any registry edit, care must be taken as any incorrect registry edit may render your PC inoperable.

Sunday, April 01, 2007

Cannot open SQL server

Problems printing non-datapiped reports in Accpac Advantage Series 5.2

The following error is returned:

Description: Cannot open SQL server

All databases in 5.2 use DSNs.  The problem occurs when multiple database types are used and the same database IDs' exist.

Example.  A Saminc and a Samsys DSN already exist on a machine from a DB2 install.  When the client accesses a Saminc database for Pervasive, a  Saminc and a Samsys DSN will be created for Pervasive on the same machine.  This creates duplicate DSNs on that machine and the above error will occur.

Remove the duplicate DSNs from Datasource (ODBC) setup.  If the database does exist with the same name for both types of databases, ie.  Pervasive and DB2, then use DBDump and DBLoad for one of them to a different database ID.

Error "A Strong SA Password is Required for Security Reasons" When Trying to Install MSDE

When trying to install MSDE included with Sage Accpac HRMS, the following error may occur:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will no exit."

The installation then terminates.This error normally occurs on Windows Server editions, but may also occur on Windows XP.

Follow the steps below to setup MSDE manually:

  1. From the Start Menu, select Run...
  2. In the Run dialog box, type in "cmd" and click OK.
  3. Complete the following commands, pressing the Enter key after each command:
  • "x:" (where x is the CD Drive where the HRMS CD is inserted)
  • "cd\msde2000"
  • "setup SAPWD="password" INSTANCENAME="name" SECURITYMODE=SQL (where password is the password you choose and name is the identifier which you choose to call the MSDE installation) (NOTE: the password must be a strong password, meaning it must contain both numbers and letters).

During the Accpac database setup, the login information will be as follows (unspecified fields can be left with their default values):

Server Name: \
User Name: sa

"Violation of PRIMARY KEY constraint 'ICUNIT_KEY_0'" when performing a DBload of data into MS-SQL

When importing data through DBLoad into a new Microsoft SQL database, the following error may  occur:

INSERT (error = 127, native code = 2627) message: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation  of PRIMARY KEY constraint 'ICUNIT_KEY_0' Cannot insert duplicate key in object 'ICUNIT'

This  error is not evident performing the same procedure in an environment running another database engine such as Pervasive. This problem may be related to an incorrectly defined Sort Order or Collation Name in the setup of the Microsoft SQL database.

To correct this problem, do the following:

Set Sort order to Case Insensitive
Set collation name to Latin_general_bin

Saturday, February 24, 2007

Pop-up Calculator

When you are in any number field, you can access the calculator by pressing the + key in the numeric keyboard or by pressing Shift + = (shortcut).

You copy and paste your result directly to the number field using Ctrl + C (copy) and Ctrl + V (paste). If your calculator has a paste button, you can use it to paste the result directly to the number field without having to copy the result first.

Error Code: 2147467259 - Automation Error - Unspecified Error

If you receive the following error message:

"Error code: 2147467259 Automation error - Unspecified error."

This may be due to restrictions on the temporary directory paths that are set in the Environment Variables on the local workstation. Change the path to a shared temp directory such as C:\Windows\Temp.

To do this, do the following:
  1. Before proceeding, please close out of all ACCPAC® programs.
  2. Click the Start button, point to Settings and select Control Panel (in Windows XP, skip the Settings step)
  3. Double click to open the System icon
  4. In the System Properties windows, click the Advanced tab
  5. Click the Environment Variables button
  6. In the User variables for [username] field, highlight the TEMP variable in the list and click the Edit button
  7. In the Edit User Variable window, change the Variable Value field to C:\Windows\Temp

Repeat the above steps for the TMP variable as well. If you want to retain the existing variable values, paste the current variables into notepad or other text file and save this file in a location where you can retrieve it at a later date if necessary.

Restart ACCPAC.

Shortcuts and Function Keys

Listed below are some Function Keys and Shortcuts that you can use in Sage Accpac ERP.

Using Function Keys - The following function keys or “Hot Keys” provide you with shortcuts:

F1 Key - Displays online help. Available anywhere in ACCPAC.
F5 Key - Displays a finder window to select records from.
F7 Key - Displays the information for a record (go button).
F9 Key - Enlarge the selected record to display more information about the record (zoom Button).

Using Menu Commands & Buttons:
Data entry forms display similar menus (for example, file and help menus) Thus you need to become familiar with only a few commands and buttons to work with ACCPAC data entry forms.
Advantage Series: Using Keyboard Functions instead of the Mouse:

Alt + S - Use to save changes made to the displayed record.
Alt + D - Use to delete the displayed records.
Page Up - Navigation buttons
Page Down - Navigation buttons
Ctrl + Page Up - Navigation buttons
Ctrl + Page Down - Navigation buttons
Alt + E - Use to set criteria to specify records to display in the finder.

Editing Columns of Data:

Insert - insert a blank row to add a new record.
Delete - remove a selected row.
Tab or Enter - Go to the next or previous column in a list.
Up or Down Arrows - Go up or down one row.
Right or Left Arrows - Go right or left in a column.
Page Up - Go to the top row in a view.
Page Down - Go to the bottom row in a view.
Home - Go to the first row in a list.
End - Go to the last row in a list.