Access: Difference between revisions
(Created page with "Microsoft Access databases can be used for a number of functions in SimpleIndex. * Use as a Data Source for Database Export * Use as a...") |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 5: | Line 5: | ||
* Use the [[Data_Source#Default|Built-In Access DB]] to instantly connect any [[Job File]] to a database | * 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 | * 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. | 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. | [[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. | |||
== Related Knowledge Base Articles == | |||
* [https://www.simpleindex.com/knowledge-base/access-database-connection-string/ Access Database Connection String] | |||
* [https://www.simpleindex.com/knowledge-base/how-do-i-connect-to-an-existing-access-database/ How do I connect to an existing Access database?] | |||
Latest revision as of 20:02, 15 August 2023
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.