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.
I am afraid you have me thoroughly confused.
I normally do NOT delete/create the tables.
I construct a new connection string, update the appropriate tabledef's .connect property and then issue .refresh.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear? Sometimes you may have an additional problem: where the devil did they go? If you last had a popup form open…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…