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…
Articles
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…
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…
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…
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…
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
