What I think I need to do is create an ODBC connection between a computer that has the Access file and the computer running the SQL Server.

Microsoft has released a temporary fix for a known issue impacting Windows apps using ODBC database connections after installing the November 2022 Patch Tuesday updates.