Uploaded July 2026 | Updated September 2026, 2 weeks ago
Today we will walk through how to connect your Microsoft Access database to SQL Server so you can use it online. I will show you how to install SQL Server Management Studio, set up an ODBC data source file, manually upload your Access tables to SQL Server, and then relink Access to use the online tables instead of local ones. We will also discuss options for setting up SQL Server locally, differences between file and machine data sources, and important points about connecting, security, and performance as you move your Access data online.
CHAPTERS:
00:00 Introduction
01:05 About the Full SQL Server Online Seminar
01:33 Overview: Steps to Connect Access to SQL Server
02:05 Installing SQL Server Management Studio (SSMS)
03:37 SQL Server Express and Local Testing
04:47 Downloading and Installing SSMS
05:44 Logging In to SQL Server with SSMS
07:48 Overview of SSMS and SQL Server Database Interface
08:11 Access vs. SQL Server Migration Tools
09:01 Reviewing the Sample Access Database Structure
09:36 Introduction to ODBC Data Connections
10:47 Setting Up a File Data Source (DSN) for SQL Server
14:45 Exporting Access Tables to SQL Server
15:53 Verifying Table Upload in SSMS
17:16 Viewing and Querying Your Data in SSMS
19:18 Linking Access to SQL Server Tables
21:36 Linked Table Security Considerations in Access
23:08 Using Linked Tables in Access Forms
23:57 Summary and Next Steps
25:15 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Connect Access: 599cd.com/ConnectAccess
PREREQUISITES:
Online Database: 599cd.com/OnlineDatabase
Online Hosting: 599cd.com/OnlineHosting
LINKS:
Access SQL Server Online: 599cd.com/SQLOnline
WinHost: 599cd.com/WinHost
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, connect Access database to SQL Server online, SQL Server Management Studio, ODBC connection, migrate Access tables to SQL Server, Winhost SQL Server, linked tables, SQL Server setup, SSMS installation, pass-through query, database security
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Today we will walk through how to connect your Microsoft Access database to SQL Server so you can use it online. I will show you how to install SQL Server Management Studio, set up an ODBC data source file, manually upload your Access tables to SQL Server, and then relink Access to use the online tables instead of local ones. We will also discuss options for setting up SQL Server locally, differences between file and machine data sources, and important points about connecting, security, and performance as you move your Access data online.
CHAPTERS:
00:00 Introduction
01:05 About the Full SQL Server Online Seminar
01:33 Overview: Steps to Connect Access to SQL Server
02:05 Installing SQL Server Management Studio (SSMS)
03:37 SQL Server Express and Local Testing
04:47 Downloading and Installing SSMS
05:44 Logging In to SQL Server with SSMS
07:48 Overview of SSMS and SQL Server Database Interface
08:11 Access vs. SQL Server Migration Tools
09:01 Reviewing the Sample Access Database Structure
09:36 Introduction to ODBC Data Connections
10:47 Setting Up a File Data Source (DSN) for SQL Server
14:45 Exporting Access Tables to SQL Server
15:53 Verifying Table Upload in SSMS
17:16 Viewing and Querying Your Data in SSMS
19:18 Linking Access to SQL Server Tables
21:36 Linked Table Security Considerations in Access
23:08 Using Linked Tables in Access Forms
23:57 Summary and Next Steps
25:15 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Connect Access: 599cd.com/ConnectAccess
PREREQUISITES:
Online Database: 599cd.com/OnlineDatabase
Online Hosting: 599cd.com/OnlineHosting
LINKS:
Access SQL Server Online: 599cd.com/SQLOnline
WinHost: 599cd.com/WinHost
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, connect Access database to SQL Server online, SQL Server Management Studio, ODBC connection, migrate Access tables to SQL Server, Winhost SQL Server, linked tables, SQL Server setup, SSMS installation, pass-through query, database security
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
