Thanks for the responses.

After further development, we changed the set up in Access to just have a linked table to SQL Server that has all the data updated. I still...