Access: Difference between revisions
No edit summary |
|||
Line 15: | Line 15: | ||
* [https://www.simpleindex.com/knowledge-base/access-database-connection-string/ Access Database Connection String] | * [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.