So I have an access application that has a front end and a back end. The front end is the application and a bunch of linked tables to the Back End access database.
Ive replicated the back end Access Database exactly the same way as it is in Access, in SQL server.
All i need to do is change the linked tables to lookup the SQL database instead of the Access database back end.
I understand the connection has to be different since we are going to an ODBC connection now.
any help please?