I've inherited an access application that consists of a number of .accdb files.
Depending on what your doing, 1 of the 2 accdb files contains most of the UI, and the other accdb files keep the data, and those files are kept on the network so everyone access the same data.
I want to convert these central accdb files (not the UI ones) to run on SQL Server. I know that there is an conversion wizard that upsizes the database to sql server, and from sql server I know I can import access data, but I don't see anywhere in the Linked Table Manager to connect to a SQL server database.
How do I do this?