Articles

Acctivate database connections with CYMA

Due to some recent changes in newer versions of CYMA (CYMA 15+), Acctivate for CYMA users have reported some conflicts in how Acctivate connects with CYMA and how CYMA reports are configured. Starting in Acctivate 10.2sp1, Acctivate now creates a Pervasive.SQL

Posted in Database

Using Remote App with Acctivate

RemoteApp enables you to make programs that are accessed remotely through Remote Desktop Services appear as if they are running on the end user’s local computer. This application can be used to provide Acctivate to remote users as well. If

Posted in Database, Getting Started, Launch Acctivate, Uncategorized

Send Database Copy to Acctivate Support

From time to time, Acctivate Support may encounter an issue that cannot be replicated in the Demo company, and may require a copy of the database with the issue for testing. This article shows how to create that backup and

Posted in Database

Create a View using SSMS Query Designer

When you install SQL Server Management Studio, it comes with a lot of very helpful database tools. The Query Designer is a way to build Select statements that can then be placed into custom views in your database. These views

Posted in Database, Technology

Locating the Server with Acctivate’s Active Database

When using more than one server, there may come a time when Acctivate’s database is copied from one server to another one. This is especially true if you have undergone a server migration at some point in the past. While

Posted in Database, Installation, Technology

Anti-Virus realtime scanning causes performance issues

Acctivate users may experience performance issues if their anti-virus uses a realtime scanning function.  Realtime scanning may constantly scan all SQL Server activity, which can be an extensive amount of data flowing between the Acctivate server and the workstations.  This can

Posted in Database, Installation, Technology

Export Acctivate Window Grids To Excel

Several windows within Acctivate, such as the sales order window and business alerts tabs, present information in a grid format. Many of these grids can be exported directly to Microsoft Excel allowing you to sort, organize and manipulate your data. To export these

Posted in Database, Reports

Can’t Find Created ODBC Connection

After creating an ODBC connection, you may find that you are not able to locate the ODBC connection when mapping to UPS Worldship, FedEx Shipping Workstation or creating a Microsoft Excel Query. In Windows, there are two ODBC Data Source Administrators: a 32-bit and a 64-bit

Posted in Database

Backup fails after moving Acctivate to a new server

Users may receive the following error when backing up Acctivate. Cannot use the backup file ‘C:\Program Files (x86)\Acctivate\..\Backup\ACCTivate$Demo.bkf’ because it was originally formatted with sector size 512 and is now on a device with sector size 4096. BACKUP DATABASE is terminating

Posted in Database, Installation

Boost Performance Solid State Drive and SQL 2014

One of the major enhancements introduced in SQL Server 2014 is the Buffer Pool Extension. This enhancement allows SQL to use the performance capabilities of Solid State hard drives. For Acctivate users, this means much faster functionality reading/writing/querying the Acctivate database. For

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