Open database integration is a powerful feature of SimpleIndex® and one that furthers its interoperability with custom programs. Instead of using a proprietary database, SimpleIndex allows you to map its index fields to cells in any database table. It can be configured to create new records, update existing ones or retrieve them for viewing. Using these three basic database functions, SimpleIndex is able to interface with and operate on any database.
SimpleIndex can connect to any ODBC-compliant data source in order to match existing data to documents or export data extracted from documents.
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
Tuesday, 29 April 2025
When connecting SimpleIndex to a Microsoft Access database that is the .accdb file type, the following Error can occur. Install the 32 bit Microsoft Access Runtime from the link below. https://www.microsoft.com/en-us/download/details.aspx?id=39358orhttp://www.scanstore.com/downloads/AccessDatabaseEngine2010.exe
No Comments
Using alternate database schemas
Monday, 29 July 2019
Please refer to the Wiki Documentation for the complete Database reference. In SQL Server, Oracle and MySQL (among others) user logons are associated with a default “schema” that determines which tables and views they can see. Users may have access to other tables and views that aren’t in their schema. When connecting to the database these tables will show up in the
Access Database Connection String
Monday, 29 July 2019
Please refer to the Wiki Documentation for the complete Access reference. If you would like to create a database string for an Access database that includes a password use this format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\database.mdb;Jet OLEDB:Database Password=db_password;
How do I delete an image and it’s database entry?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Global Settings Wizard reference. If your Job Settings Wizard configuration’s of Database mode setting is set to “Update Existing Records”, the database record and the image will be deleted when you delete an image from a batch. The Table Name must be an updateable query or table
- Published in Database & Retrieval
How do I export index data to a database?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Export reference. There are a variety of ways to connect to your database. Detailed instructions are provided in the Manual (check the Help menu). Here is a brief overview of the steps involved: -Create a job configuration to scan and index files -On the database tab, set the
- Published in Database & Retrieval, Export
Is it possible to have the scanned image itself added to a database and not just the image path?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database reference. Yes. Image files can be inserted into binary fields in Access, SQL Server, Oracle, MySQL and other databases. Check the “Store files as binary objects” option on the Database tab and the “Output File Field” setting can be mapped to a binary field. If using PDF,
- Published in Database & Retrieval, Export
When exporting to a database, I get the error “Multi-step operation generated errors”
Wednesday, 28 February 2018
or a text value that is longer than the maximum length of the f
- Published in Database & Retrieval
Is it possible to restrict user access to certain documents in Retrieval Mode?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database Mode reference. If the database you use to store index information has security access features, you can use these to manage access to documents with SimpleIndex retrieval mode. In your database, create user accounts and groups and assign them the appropriate permissions to records in your document
- Published in Database & Retrieval
How do you configure full text searching in Retrieval mode?
Wednesday, 28 February 2018
Please refer to the Wiki Documentation for the complete Database Settings reference. On the Database tab there dropdown in the lower portion of the panel for Full Text OCR Field. Put the name of the field that will store the full-text data there. This must be configured both for Insert and Retrieval mode configurations. The database field
- Published in Database & Retrieval, OCR
What is “Match & Attach” mode?
Wednesday, 28 February 2018
if you have a large backfile of documents that you want to scan and link to records in an existing database
- Published in Database & Retrieval, Export
How do you configure the Autofill feature?
Wednesday, 28 February 2018
The Autofill feature of SimpleIndex is an easy way to associate many index fields with one document without retyping data that already exists in another application. Autofill uses a database lookup to retrieve records that match a key value or values entered by the user or extracted with SimpleIndex. Blank index fields are then filled
- Published in Database & Retrieval, Indexing & UI
How do I connect to an existing Access database?
Wednesday, 28 February 2018
SimpleIndex has the ability to export, query or autofill from an Access database. This allows you to upload data that is indexed with SimpleIndex to a table or query, search against the database or pull information from the database based on a key value. Insert New Data Open the Job Settings Wizard and go to
- Published in Database & Retrieval
I know nothing about databases. Can I still use the database and Retrieval Mode features?
Wednesday, 28 February 2018
Yes! We’ve made it simple to create a database that you can use to store index information and perform searches with SimpleIndex Retrieval Mode. Once you have configured a SimpleIndex job to scan and store documents on your network, use these steps to create a database to store index information for searching: Go to the
- Published in Database & Retrieval
