Table of Contents
INSTALL ACCMATRIX AND THE MySQL DRIVER ON YOUR COMPUTER #
(You only need to install the drivers once on your computer)
1. DOWNLOAD THE PROGRAM FILES
Download the Accmatrix install file
Install the files to the folder C:\Accmatrix
2. INSTALL THE MYSQL DRIVER ON YOUR COMPUTER
2.1 DETERMINE IF YOUR EXCEL VERSION IS 32-BIT OR 64-BIT?
Open Excel
Click on <File> <Account> <About Excel>
2.2. INSTALL THE MYSQL DRIVERS ON YOUR COMPUTER
If your Excel is the 32 Bit version
2.2.1. Install the files
2.2.1.1 VC_redist.x86 (This is only required if Windows Visual Studio C++ is not installed on your computer)
2.2.1.2 Mysql-connector-odbc-8.0.28-win32 (This file installs the MySQL drivers to access the internet accounting database)
If your Excel is the 64 Bit version
2.2.2. Install the files
2.2.2.1. VC_redist.x64 (This is only required if Windows Visual Studio C++ is not installed on your computer)
2.2.2.2. MySQL-connector-odbc-8.0.27-winx64 (This file installs the MySQL drivers to access the internet accounting database)
3. SET YOUR REGION SETTINGS TO “English (United Kingdom)” or “English (United States)” TO SET DECIMAL POINT TO A FULL STOP
From the Windows Icon, Type “Control Panel”
Click on <Region>
Select Additional settings…
4. SET THE MACROS ENABLED
(This step is unnecessary, but if you don’t set it up, you must <Enable Macros> every time you start the program.)
Open Excel. Select <File> <Options> <Trust Center> <Trust Center Settings> <Macro Settings>
Select the option[Enable VBA Macros].
5. CREATE A SHORTCUT TO THE “TEST COMPANY” FILE
Click on the folder C:\Accmatrix.
Right-click on the file “Accmatrix – Test Company.” Select Send To Desktop
6. SET THE START ICON TO MAXIMISED
Click on the file “Accmatrix – Test Company” and Select <Properties>
Select the Run option to “Maximised.”
8. TO RUN THE TEST COMPANY
Click on the shortcut “Accmatrix – Test Company.”
Click on the shortcut file.
Type User Name “Administrator”
Password “Admin”
FILL IN THE APPLICATION FORM TO SET UP YOUR COMPANY.
AN INTERNET DATABASE WILL BE CREATED EXCLUSIVELY FOR YOUR COMPANY. AN “Accmatrix – [your name]” FILE WILL BE SENT TO YOU WITH THE CONNECTION TO YOUR COMPANY DATABASE.
For more information about installing MySQL drivers. <click here>