How to open a Microsoft Access Database with InfoFind

Introduction

Microsoft Access is one of the most popular and widely used Databases in the World and it comes as part of Microsoft Office. However, Access is not installed with all versions of Office and it is not on all Computers. If you need to view the contents of an Access Database but do not have it then you can use InfoFind to do so. You can also use InfoFind to view Access and other Databases on the same screen with one program. To connect to an Access Database follow the steps in the document.

Opening the Databases Form

You can access the Computer History Form from the menu [Database]->[Open Databases] or you can also access the Form from the side panel on the left side of InfoFind under [Database]->[Open a Database].

Omnicognic InfoFind Database Side Panel  Omnicognic InfoFind Database Menu

Connecting to the Access Database

  1. After you open the Databases Form the Database toolbar will appear at the top of InfoFind. Click on the first button [Database Connection Properties] in the toolbar.
    Database ToolBar
  2. You will then see the Database Connections form. Create a new connection by clicking the [New Database] button at the bottom of the form. Then click the […] button to build the connection string.
    Database Connections
  3. You will then see the Data Link Properties Dialog. Select “Microsoft Jet 4.0 OLE DB Provider” and click [Next].
    Data Link Properties
  4. Select the Access Database File and enter additional settings if needed and then click [Test Connection].
    Data Link Properties
  5. If the connection is successful then you will see the following message prompt. If you receive an error then check the settings to make sure everything is ok. If you are unable to connect then contact Omnicognic Support.
    Test Database Connection
  6. After setting up the connection select “Microsoft Access” from Database Type and click [Ok] to save your changes.
    Database Connections

Viewing the Database

You will then be able to view the Access Database along with any other database that you’ve added to the connections list. A filter at the top allows you to quickly filter through the tables and database objects to help you find what you are looking for. This is useful for large databases. On the upper-right of the form is a work area where you can run database commands (SQL Statements). Whenever you click on a database object from the list on the left side a command will appear on the right and the results will appear in the bottom-right. By default the first 100 records will be shown for each table. For additional help please review the main topic on the Databases Form.

Omnicognic InfoFind - Databases Form