Access: Difference between revisions

Revision as of 16:34, 17 January 2022

Microsoft Access databases can be used for a number of functions in SimpleIndex.

Use as a Data Source for Database Export
Use as a Data Source for Autofill
Use the Built-In Access DB to instantly connect any Job File to a database
Store value lists for List fields and OCR Dictionary matching

When using Access as a back-end database for Multi User processing and search, it is recommended for no more than 5 simultaneous users or 500,000 document records. Using Access with too many users or records can significantly impact performance.

SQL Server, MySQL or Oracle database servers should be used instead of Access for projects with any significant volume.

You can still use Access to view and edit the data on those servers via linked tables.

@@ Line 5: / Line 5: @@
 * Use the [[Data_Source#Default|Built-In Access DB]] to instantly connect any [[Job File]] to a database
 * Store  value lists for [[List]] fields and [[OCR]] [[Dictionary]] matching
-* View and edit data stored on a database server with linked tables
 When using Access as a back-end database for [[Multi User]] processing and [[search]], it is recommended for no more than 5 simultaneous users or 500,000 document records. Using Access with too many users or records can significantly impact performance.
 [[SQL Server]], [[MySQL]] or [[Oracle]] database servers should be used instead of Access for projects with any significant volume.
+You can still use Access to view and edit the data on those servers via linked tables.