What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

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.