IMPORTANT: When creating ODBC connection, verify the version of MS Access being used (32/64bit)
Run ODBC Data Sources (32/64bit) as Administrator
Go to ‘System DSN’ tab
Click ‘Add’
Choose ‘SQL Server’, click ‘Finish’
Populate the fields as follows. Click ‘Next’ twice
Place a check mark on ‘Change the default database to’, and choose ‘slweb’.
Click ‘next’, then ‘Finish
Click ‘Test Data Source’
Confirm if test is successful.