Setup ODBC for MS Access

Summary

A MS-SQL database has been created as an external data source for LaserFiche.  This data can be accessed and edited through MS Access to approved personnel.  Using this connection requires an ODBC connection. (For ODBC setups other than the SEHD LaserFiche connection, the following will still work except the database specific information will need to be adjusted.)

Creating ODBC Connection in Windows 10

If you have been given access to this database, follow the following instructions to setup the ODBC connection.  VPN will be required to test or connect to the database.

  1. Search for "ODBC" in the search bar
  2. Choose "ODBC Data Sources (64-bit)"
  3. Click "Add"
  4. Driver = SQL Server (or ODBC Drive 17 for SQL Server for older versions of OS)
  5. Click "Finish"
  6. Add the following information:
    Name = LF_CLED  (this is the name used in the MS Access file. If yours doesn't match, Access will complain when try to open the tables)
    Description = External Data Source for LaserFiche (or your preferred variation)
    Server = ED-DBSRV.ed.tamu.edu
    Click Next.
  7. Authentication Step.
    • For A&M managed computers, "Use Windows NT authentication using the Network Login ID" (for CEHD computer) [or potentially called "Active Directory Integrated authentication"]
    • If using a home/non-TAMU computer, use  ("With Active Directory Interactive authentication using a login ID entered by the user" or "With SQL Server authentication using a login ID and password) and enter your username/password ( AUTH\netid with password )
    • Click Next
  8. Change the default database to = LF_CLED (leave the rest as default).  Click Next
  9. Check the box "Trust server certificate." (if it exists) Click Finish.
  10. [May not be in the wizard] Click "Test Data Source" to verify the settings.  (If the test fails and you can't determine the mistake, send the test results to Arlen Strader (strader@tamu.edu) to track down the issue.
    • If see screen #10: If tests completed successfully, click OK on each window to close them.
  11. If see a screen like attacked "Screen 11."  Select the boxes in the image and click "Finish."

If you successfully setup ODBC, open the MS Access file.  Click in the tables to verify you can see the data.  Also, try to edit something like a name in the data to see if you have those permissions as well.

 

Print Article