Currently I have a back-end Access database with just my Tables and relationships and a front-end with my queries, forms and reports.
I would like to leave my front end in Access and just move my back-end Tables to SQL and I have a few questions.
1. Will the relationships get moved as well as only see an option to move the tables.
2. Once I move the tables and then link my back end to the SQL the links now appear as dbo.table instead of just the table name with a link arrow. none of my queries work because they all refer to the previous link Table name and not the dbo.Table. I have several dozen Queries. Is there an easy way to fix this?
Thanks,
Sam