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 Tables   Connection strings reference: www.connectionstrings.net Download the ODBC Driver 17 for Sql Server: https://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 (515) 239-9900 ______________________________________________________________________________ Hire us for a project https://www.winningsolutionsinc.com/C... ______________________________________________________________________________ https://www.microsoftaccessexpert.com https://www.winningsolutionsinc.com SOCIAL MEDIA www.facebook.com/AmesWSI www.facebook.com/MSAccessExpert www.twitter.com/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 YouTube 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: www.facebook.com/AmesWSI, www.facebook.com/MSAccessExpert, www.twitter.com/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