The Microsoft Query Wizard is an easier way to quickly create a Microsoft Query right from Excel. The basic steps to setup a Microsoft Query using the Query Wizard are below, these may vary slightly depending on your version of Microsoft…
Articles
“Acctivate data source not found…”
This message appears when you don’t have a data source with the name of “Acctivate” in Acctivate database maintenance. Acctivate allows for multiple data sources to be configured in database maintenance (or the acct.ini) but at least one of these…
Posted in Database, Installation
How to attach files using notes in Acctivate
Users may upload and attach files to a record in Acctivate, using notes. Users may create notes and upload attachments on the following windows. Activity Customer Account Customer Credit Customer Location Sales Order Sales Invoice Purchase Order Purchase Invoice Product…
Enabling TLS to resolve “Unable to login to database server”
TLS 1.0 is a protocol used to provide privacy and data integrity between two communicating computer applications. The following “Unable to login to database server” message could occur if TLS 1.0 is disabled. In order to check to see if…
Posted in Database
Delete Warehouse from a Product
Occasionally, you may want to remove a warehouse on a product. This does not remove any historical transactions, or delete the warehouse from the database. Removing the warehouse from a product hides the warehouse only for the product you are…
Product Class: Product Class is ambiguous
As your business grows and you have the need for more and more product classes, the list can grow to a point that you may have accidentally created a duplicate Product Class. The database must have a unique identifier to…
“Operating System error system may not find the file specified e:\sql10_main_t….” when attempting to start the SQL Server service
A new installation of SQL Server 2014 express may present problems when starting the service at the end of the installation. You can attempt to start the instance by hand using “Service.msc”, browsing down to SQL SERVER (ACCTIVATE), right clicking…
Deleting Customers from Acctivate
You have old, inactive or duplicate customer records, now you want to delete them. Acctivate does not allow users to delete customers once a record has been created. While it may sound like a simple click of the mouse or…
Migrating data from one Acctivate company file to another company file
For some users with multiple Acctivate Companies, there may come a time when you would like to migrate the data in one of the companies into the other. This can be due to a merger or a variety of other…
Stop Excel from Changing Numbers to Dates or Scientific Notations
We all know that Excel can be a powerful tool, however in an effort to anticipate the need of a user, Excel can also make it difficult to create spreadsheets for importing data into Acctivate. You may have entered a…
Posted in Database, Import Data
