Networking a Microsoft Access Database

Technosoft highly recommends Microsoft SQL Server 2008 or later as the database server for Inquest.

 

For the first workstation follow the steps outlined for creating a new Microsoft Access database.

http://www.technosoftinc.com/faq/AccessNew.htm

 

For additional workstations using the same database follow these instructions:

 

1.    Start Inquest

2.    The first screen to display is “Open Company Data Source”

3.    Click the “New data source…” button

4.    The “Data Connection Wizard” will display

5.    Select “Open an existing database”, click “Next”

6.    Select “Microsoft Access Database”, click “Next”

7.    Click the Browse button

8.    Browse to and open your existing Microsoft Access database file for Inquest

9.    Click “Open”

10.  Click “Finish”

 

The program will now open with your existing database.

 

Opening Inquest in the future will show your company database in the “Open Company Data Source” database list.

 

 

Determine Filename and Location

 

Step 8 above requires you to know where your Inquest database is located.  The following procedure can be used to determine the correct database filename and its location.

 

From the workstation used to create your Inquest database. 

 

1.    Start Inquest

2.    The first screen to display is “Open Company Data Source”

3.    Highlight the company name in the database list

4.    Below the list of database names you will see “Location”.  The location will give the full pathname and filename for the Microsoft Access database

Use this information when networking additional workstations