Smartstaff, administrator
686
edits
Changes
deprecating
{{Deprecated}}
==Overview==
The [[SmartSimple]] Access [[:Category:Plug-Insfor Microsoft Office|Plug-In]] feature is used in conjunction with [[SmartSimple]] reports to merge information from these reports into an Access Database.
* Each report you run will create a new table in the database (or optionally append data to an existing table).
* Once the tables are created you can apply any formatting, link the table to other tables, or create any additional queries and reports that you need.
* This document describes how to install and use the Access [[:Category:Plug-Insfor Microsoft Office|plug-in]].* This [[:Category:Plug-Insfor Microsoft Office|plug-in]] will work with Microsoft Access versions 2002 and 2003.
==Installing the Access Plug-In==
You can download the latest copy of the Access [[:Category:Plug-Insfor Microsoft Office|Plug-In]] from your copy of [[SmartSimple]].
1. Select the '''Help''', '''Downloads''' [[Menu|menu]].
==Adding the Plug-in to MS-Access==
* The Access [[:Category:Plug-Ins|plug-in]] must be installed to a specific database. It cannot be globally installed for all databases.
* Once installed in the database you must open the database through the Windows file system. Do not launch Access and try to open the database, as the [[SmartSimple]] [[Menu|menu]] will not be displayed.
* The [[:Category:Plug-Ins|plug-in]] is a DLL format and is installed through the Tools, ActiveX Controls [[Menu|menu]].
1. Launch '''Microsoft Access'''.
==Configuring the Access Plug-in==
* The first time you use the Access [[:Category:Plug-Ins|Plug-In]], you need to input your [[SmartSimple]] credentials ([[Username|username]] and [[Password|password]]) and the setting of the [[SmartSimple]] server that you access.
* If you have previously installed any other [[SmartSimple]] integration features (Word, Excel or Outlook), then your [[User|user]] setting will already be established.
==Generating a Report in Access==
The purpose of the Access [[:Category:Plug-Ins|Plug-In]] is to display the results of reports created in [[SmartSimple]], in an Access table.
1. Click the '''SmartSimple Reports''' button.
==Common Errors==
Common errors you may encounter when using this [[:Category:Plug-Insfor Microsoft Office||plug-in]] are:
1. User does not have access to a report due to their role.
This feature stores [[User|user]] information in a file: SETTING.INI, in the Microsoft Office/Office/ folder on the C: Drive. If this folder is protected, then the system will not work.
The [[User|user]] must have write access to this folder in order for the Access [[:Category:Plug-Ins|Plug-In]] to operate. [[Category:System Management]][[Category:Plug-Ins]]
