Saturday, May 03, 2008
Windows Registry Editor Version 5.00
"UrlAllowList"="\\\\servername\\Accpac\\Sage54\\help;file://\\\\servername\\Accpac\\Sage54\\help"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
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.
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:
- From the Start Menu, select Run...
- In the Run dialog box, type in "cmd" and click OK.
- Complete the following commands, pressing the Enter key after each command:
- "x:" (where x is the CD Drive where the HRMS CD is inserted)
- "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):
User Name: sa
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
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."
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:
- Before proceeding, please close out of all ACCPAC® programs.
- Click the Start button, point to Settings and select Control Panel (in Windows XP, skip the Settings step)
- Double click to open the System icon
- In the System Properties windows, click the Advanced tab
- Click the Environment Variables button
- In the User variables for [username] field, highlight the TEMP variable in the list and click the Edit button
- 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.
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.