MS Access Tutorials: Linking and Re-linking SQL Server Databases

We follow up a previous video (link below) about linking an two Access databases, a data-only file (back end) and an application file (front end). What if the front end is not in Access, but, as we often recommend, in SQL Server instead? We think it would go something like this...
DSN connections are convenient, easy to create, but not portable between computers
DSN-less connections are recommended in most cases, and refer to the parent tables by a string containing the server login, as opposed to a DSN which must be created on each individual PC that the front-end database is copied to.
* Previous video on linking Access databases: • Linking and Re-Linking...
* Connection strings reference: www.connectionstrings.net
* Download the ODBC Driver 17 for Sql Server: bit.ly/3GU2TOo
0:00 Intro
0:54 Setup
2:07 Creating a DSN Connection
7:36 Linking tables from DSN Connection
11:25 Creating a DSN-less connection
13:50 Reconnecting table through the DSN
14:22 Remove DSN (to simulate copy to another PC)
15:10 Reconnect through only the code (DSN-less)
15:53 Conclusion & Outro
WINNING SOLUTIONS, INC.
836 N. 2nd Street
Ames, Iowa 50010
[phone]
______________________________________________________________________________
+ Hire us for a project www.winningsolutionsinc.com/C...
______________________________________________________________________________
www.microsoftaccessexpert.com
www.winningsolutionsinc.com
SOCIAL MEDIA
AmesWSI
MSAccessExpert
WSITech
/ msaccessexpert
/ winning-solutions-inc-
Welcome to Winning Solutions Inc., your one-stop-shop for Microsoft Access solutions. Our team of experts is dedicated to providing you with the best possible service for your Access database needs. Whether you need help with an existing database or want to create a new one, we're here to help.
In addition to providing Access database solutions, we also offer cloud migration, .NET desktop, web, or mobile application conversion, and more. We work on most anything to do with Microsoft Access, so if you're not sure if we can help, just contact us to find out.
If you're looking for free Microsoft Access tutorials, you're in the right place! We love making RUclips videos, code samples, and templates to benefit the Access community. If you have ideas for other videos, please leave a comment with your suggestions.
If you found this video useful and would like to see more free Microsoft Access tutorial videos, please click the like button and subscribe to our channel. And, if you feel that you get value from our channel and would like to compensate us, you may do so via the following crypto currencies at these links: BTC, ETH, and LTC.
For more information about our services, visit our website at www.winningsolutionsinc.com. And be sure to follow us on social media for updates and news: AmesWSI, MSAccessExpert, WSITech, and www.linkedin.com/company/winningsolutionsinc/.
Thanks for watching, and we look forward to helping you with your Microsoft Access needs!
BTC
3FNbZTZcGtZhXuijcsoV4JrZv2E74aLBwc
ETH
0x72c3b3c976bf0a40953693909fb30a3bdaa23bc6
LTC
MUnUgvzRquK8GqmbMKDjbuwxDX6LgRAjts