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.

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

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

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

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.

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

Microsoft said that future SQL Server APIs will phase out of OLE DB and back to supporting the Open Database Connectivity protocol.