I am not having any luck setting up a connection from Access to SQL. I am running SQL Express connecting to a local DB on my laptop, for testing purposes before integrating into our standard environment.
I have setup the database using Windows authentication without issue and have setup a few sample tables. I'm looking to connect to this database via Access for ease of viewing & dumping data when needed. I am just more familiar with Access and like it's user-friendliness.
Many questions: what driver do I use? SQL Server, ODBC Driver 18 For SQL Server? I assume my server name is "Losses" according to this screenshot?
If that's the right DB name, then wondering why I keep failing authentication.
Any help would be greatly appreciated.
