If you do not have a SQL Server account, you will need to contact Heather Brase at Heather.Brase@mobap.edu.
| Make sure Remote Applications are Available |
|---|
| Before attempting, be sure to have remote applications available by setting up the remote connection which can be done by following the directions in the Remote Desktop Access ***NO LONGER SUPPORTED*** KB Article. |
| Establishing the ODBC Connection |
|---|
To setup the ODBC connection, open the File Explorer (Work Resources) application (sign in if prompted). Looking at the options on the left hand side, Navigate to the System (C:) or your Local Disk Drive. When on the C:, use the top right search bar to search for ODBC Data Sources. You will need to select the ODBC Data Sources (64-bit), or (32-bit) if needed from the list of choices when the search is finished. If there is two of an option, either will work as they are just two different paths to the same option.
|
| Setting up ODBC - Setting Up CAMS DB for MS Access |
|---|
Control Panel\System and Security\Administrative Tools\Data Sources (ODBC).lnk
Default Option
Default Option
|
| Access |
|---|
| Once ODBC is Configured, you can close out and navigate back to your remote apps. Use the Access 2016 (Work Resources) and you should be able to run queries as needed. |