Connecting to SQL Server from a Microsoft Access Database

from Computer Learning Zone · host Richard Rost

In this episode, we connect Microsoft Access to SQL Server by setting up linked tables rather than importing, so your Access front end works with live server data. I show you the step-by-step connection process, discuss choosing the right ODBC driver, explain the difference between file and machine data sources, and clarify how to handle the DateTime2 data type. You will also learn about managing DSNs, common pitfalls in setting up connections, and some best practices for naming conventions and maintaining compatibility between Access and SQL Server.

Episode metadata supplied by the publisher feed · Published Feb 24, 2026

Embed this episode

Attribution link and audio player

NOW PLAYING

Connecting to SQL Server from a Microsoft Access Database

0:00 24:11

1×

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

Share this episode

Similar Episodes

No similar episodes found.

Similar Podcasts

CISO Perspectives (public) N2K Networks This season on CISO Perspectives, host Kim Jones explores some of the challenges of leading through uncertainty. We explore the complexity of the changing nature of regulation and working with the federal government, the evolution of privacy and fraud, and how emerging technologies like AI and quantum computing are changing cyber. When you don’t know what questions to ask, you’re afraid to ask, or don’t know who to ask, CISO Perspectives provides the foundation for learning in this brave new world.

Frequently Asked Questions

How long is this episode of Computer Learning Zone?

This episode is 24 minutes long.

When was this Computer Learning Zone episode published?

This episode was published on February 24, 2026.

Can I download this Computer Learning Zone episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.

URL copied to clipboard!