Creating an ODBC Connection (Microsoft Access)

On your local computer, go to “Control Panel > Administrative Tools”.
On 64-bit versions of Windows, you will see two icons: ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit).
Select the proper applet.

odbc data source administrator

Select the Microsoft Access Driver from the list and click on “Finish”.

Microsoft Access ODBC driver

Enter the connection information:

Microsoft Access ODBC configuration

Data Source Name must be “SIW”

You should now be able to use this ODBC connection within your software applications (including SIW).