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.

To access the files on the server, each employee and user must initiate a remote connection to the server over an active Internet signal.

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 ...

2SQL from Australia-based ConvertU2 aims to ease the migration from Microsoft Access to SQL Server.

I'm new at this whole DBA thing, so maybe this is totally standard practice.But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install software ...

From that standpoint, moving to ODBC-based APIs for SQL Server may make things easier for developers who are considering porting their SQL Server-based applications to Microsoft's cloud.