I want to do something I have not done before and need some expert advice/direction. I want to connect an Access 2016 database front end to a SQL Server 2016 back end--the tables will reside in the SQL Server database. The front end application will reside on multiple users' computers (about 8) who will run the Access front end application using the Access 2013 runtime version. I have created a machine ODBC connection and successfully linked the tables to the Access front end on a single machine where I have the full version of Access on the same machine as the SQL Server database resides (full version). From what I've read, I think I need to create an ODBC connection and/or a Data Source file so that each computer sees the linked SQL Server tables. The research I've done has pointed me in what appears to be different directions and none of them includes an Access runtime. Can anyone advise me as to the best way to go and especially HOW to create the connection between the front end and back end so that I do not have to create the connection on each of the 8 user's computers. I'm shying away from VBA code based on what I've read. This is the first time I've done this with SQL Server as the back end, although I have used Access as the back end many times where I just need to be sure the users' computers have the same path to the back end. So, how do I create a connection that I can copy to each user's computer using the Access runtime? Pardon me if I am not phrasing this correctly.
I appreciate your help!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.