From the course: Migrating Access Databases to SQL Server

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Linking to ODBC databases

Linking to ODBC databases

From the course: Migrating Access Databases to SQL Server

Start my 1-month free trial

Linking to ODBC databases

- Using the SQL server migration assistant, we were able to move existing access tables and queries into SQL server. Another way to get the same benefit is to create the objects in SQL server first, and then link them back to the access frontend. In order to do this, we will need to make use of something called ODBC or an Open Database Connectivity Interface. In order to create an ODBC connection, you'll use a tool that's built into the operating system. If you're on Windows 7 or earlier, it'll be called the ODBC Data Source Administrator. On Windows 8 and later, it'll simply say ODBC Data Sources. On 64-bit machines, you'll see both a 32-bit and a 64-bit version, and you should just choose the version that matches your installation of SQL server. You can find the tool through the Control Panel, and it'll run through a simple wizard to create and verify a connection to a database. Once you're done, the database will be made available as a data source to any other program that comes…

Contents