In this tutorial I’m going to walk you through the necessary steps to:
- Create ODBC Connection between Spiceworks and 3rd party application (Demonstrated using MS Access).
- The possibilities of advanced report customization.
- Create dynamic reports by asking the user for a value before retrieving the information from Spiceworks Database.
SQLITE ODBC Drivers can be downloaded from: http://www.ch-werner.de
Be careful! DO NOT create an ODBC connection to your live Database file!
Creating an ODBC connection to Spiceworks live database file may corrupt your database.
Always make a copy of the database file, and create an ODBC connection using the backup file.