Asset Tracking Install

Asset Tracking was developed to track C02 Dry Ice Bins but can be used to track anything.

 

Install Git For Version Control

  • Install Git For Windows
https://git-scm.com/download/win

Download Files

  • Download the files from the code repo by running the following command in a terminal window in the directory you wish to install.
git clone https://github.com/ItsYaBoyFish/Access-Asset-Tracking

Installing Fingerprint Reader Drivers

  • Anytime this prompts you to restart wait until this entire section is complete as it would require several and you can just do it all at once.

  • First, open the project folder and open the Installs folder and click on the folder labeled FPReader10

  • Inside of that folder, you will have to choose the 32 bit or 64 bit version depending on the machine you are working on. Once inside the proper folder, there will be an option labeled "Run This One". Run that file and perform all default selections.

  • Next, you will go back to the Installs directory and open the folder labeled FPReader07.

  • Run the file labeled "Run This One".

  • Again, follow all default prompts for this one.

  • Now, go back to the Installs directory and pick the folder FPReader10 again and choose the same bit size (32 or 64)

  • Run the file again named "Run This One" but this time run a repair instead of the default install.

  • Now restart the computer

Initial Startup

  • You may be prompted when opening the app for the first time to Enable Content. Please do so. Otherwise the system will not function.

  • If you open the Options menu in Access, locate the Settings Option called trust center. You are looking for something called “Trusted Locations”. You may have to select the “Advanced Options” button if you are using a 2007 install. You will want to add the folder containing the Access File to the Trusted locations Menu. Then Make sure to check the box that allows everything in the directory to be enabled. Then click ok.

  • Once content is enabled, you will be asked to Verify The ODBC

Creating the ODBC Connection

  • If you have completed this process already, you can skip to the next section.

  • Hit the Windows key on your keyboard and type ODBC

  • There will be an option for 32 bit or 64 bit, we do both of them and you will repeat these exact steps for both, so it doesn’t matter which one you start with.

  • Once opened, at the top of the dialog box that opened there is tabs. Click the one labeled System DSN

  • Then click Add

  • Select the Driver called SQL Server Native Client 11.0 (This is usually found at the very bottom of the list). Then click Finish

  • Next you will Name the ODBC. Name it the following

Asset_Tracking

  • Don’t worry about the Description.

  • ** If the sql server connection details havent been given to you, contact Austin or Lance.

  • Type in the Server Name and click Next

  • Choose SQL Server Authentication and type in the Login ID and Password. Then Hit Next

  • Mark the select box to change the Default Database and change it to the Database labeled Asset_Tracking and click Next

  • Leave everything alone on this page and click Finish

  • Now click Test Data Source. You should see a Test Completed Successfully. If so, click Ok and repeat these steps for the other operating system size (32 or 64 bit). Once they are both done, you can move on to the next step.

  • If you get an error be sure to check all of the details by clicking cancel and using the Back button to navigate to verify the details you entered.

Setting Access To Use ODBC Connection Just Created.

  • Open the Access Application Up.

  • On the tabs in the top of the Access UI, click the External Data tab.

  • Go to New Data Source (All the way to the Left)

  • Choose From Database, then From SQL Server

  • Choose the option that says Link to the data source by creating a linked table and click Ok

  • Towards the top of the little dialog box are 2 tabs, one labeled File Data Source and Machine Data Source, click the one called Machine Data Source

  • From the list of Data Sources, choose the one called Asset_Tracking and click Ok.

  • You are going to get a popup of the database table structures. Select any table that has the words dbo. in them.

  • You should have clicked the following tables.

Table Name
dbo.AppSettings
dbo.AssetInventory
dbo.AssetLog
dbo.AssetsPreppedForDelivery
dbo.DeliveryLocations
dbo.Employees

  • Check the box that says Save Password

  • Then click Ok.

  • You will get a prompt for each table verifying you wanted to save the password. Click Save Password for each.

  • After that, click the Green button in the ui labeled Verify ODBC Connection

  • If all is well, you will get a prompt that is labeled Workstation Setup. Just follow the prompts now and it will walk you through generic info needed for setup.

Importing Data

  • You have the option to import 2 categories of data. Employees & Customers

  • The format is a CSV file with column names required. (As the system skips the first line to account for this and it helps with filling out the form in the UI)

  • Hit the F11 key on your keyboard while the Asset Tracking Application is open.

  • In the search bar type in Import. This will filter the list and make it easier to find.

  • Open the Form labeled Import Data

  • Now follow the prompts on screen.