linking problem after moving from azure access table to azure sql server
I am moving our database from azure access which is on a Microsoft server which can not be modified using the azure portal to sql on the azure portal. The end goal is to create asp.net pages in azure. During the rewrite the user need to be able to up date the old system.
I was planning to change the odbc link to the new server information. Which I could get each user to do with instructions. The problem is that this causes an ODBC error. The issue is the SQL server table names are being qualified with dbo. and the access tables was not. Is there a way to stop the qualification at the odbc level so it is easy to relink the tables. I tried programmatically trying to create the links in the form open event but I keep getting errors.