We currently have a split Access database. We need to convert the back-end, so that all the data tables will be stored on SQL Server instead of in the back-end Access database directly. I was able, through the Upsizing Wizard, to move all my data tables to SQL Server.
Now, I am trying to re-point the table links in my Access front-end database to look at the SQL server database instead of the old Access tables. I set up an ODBC connection to the new SQL database, but I cannot figure out how to re-point what those tables links are pointing to (through the Linked Table Manager). The Linked Table Manager does not seem to show the SQL server or ODBC connections.
How do I do this?
Thanks