description: Learn how to link your Access tables to the migrated tables so that you can use your existing Access applications with SQL Server or Azure SQL Database.

If you have a legacy MS Access database or like its GUI, then there are ways to boost its abilities by teaming it up with SQL.

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

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

Conclusion While MS Access has its strengths, particularly for small-scale applications, it may not be sufficient to meet the demands of a growing business. Converting your MS Access database to SQL ...

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.