Articles

Send Database Copy to Acctivate Support

12-5-2016-11-09-50-am

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

ssmsquerynew1

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

databasesources

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

What’s new in Sql Server 2014?

Acctivate version 10 comes with an Express instance of Sql Server 2014. Checkout this Microsoft article which lists “what’s new” in detail.

Posted in Database, Installation

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
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.