Crystal Reports not locating all database views or new fields

There are times when modifying a report using Crystal Reports, the report will not display all the table/view information (i.e. new fields). Maybe the report is pointing at an old database or possibly a completely different database. You will have

Posted in Database, Reports

Modifying an existing Microsoft Query in Excel

Microsoft Excel, when linked to an Acctivate database via ODBC, can be a useful tool to quickly return data from Acctivate. Acctivate QuickBooks Inventory Software was designed to automate, track, simplify and securely manage growing business needs all within the

Posted in Database, Reports

CYMA error “Could not find server ‘(server)’ in sys.servers…”

This error is often found by CYMA users shortly after migrating to a new server. The error is usually caused by some change in a CYMA database field name. In the example above, we see that the Sales Order cannot be saved because

Posted in Database

Appending a date at the end of a backup file using Task Scheduler

If you are following the Automatic Backup article, you may have a need to append the date at the end of the file which cannot be done using the arguments in task scheduler. To do so, you would need to

Posted in Database, Technology

“Backup failed…” sector size error when restoring a backup file in Database Maintenance

When restoring data from a backup file Acctivate’s Database Maintenance tool, the following error may be returned: This is a fairly uncommon error resulting from a difference in the database format of the backup file and the format of the

Posted in Database

“External component has thrown an exception” may be received when logged in to Acctivate for extended period of time

When users remain logged in to Acctivate for an extended period of time (i.e. overnight, or for several consecutive days), occasionally the following error may be returned when saving records or posting transactions: This error is often workstation-specific. The solution for

Posted in Configuration, Database

Change Backup Directory

When selecting to back up your data from within Acctivate, Acctivate sends a command to Microsoft SQL Server to start a backup.  Microsoft SQL Server typically sets the default location of Backups to be within the SQL Server instance subdirectories.

Posted in Database

Add database objects to an Acctivate Database

For a myriad or reasons, companies may create customized database objects, such as additional tables, fields, Indexes, etc., within an Acctivate database.  If your company intends to create these objects within an Acctivate database, you should always add an underscore prefix to the

Posted in Database

Error running database update: Create failed for Index…

The following exception may occur during an Acctivate database upgrade if records exist with duplicate “key values”.  This problem is not very common, but it can potentially block a database upgrade until the duplicate key values are resolved. Error running database update:

Posted in Database

Install Microsoft SQL Server 2012 Standard Edition

NOTE: The following article is regarding SQL Server 2012.  We recommend starting with a newer version if possible, but the following my be useful if you need to (re-)install SQL Server 2012 Standard Edition.  Please contact the Acctivate support team for questions

Posted in Database, Installation
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.