Forum Discussion
Updating a Azure SQL Linked Table From Local Tables
Hi All I am working on a work around to get my access database ready to deploy as its needed urgently. The work around that I want to use, is to upon form open have the Access frontend pull a...
Well, no time to confirm, but I "THINK" the problem is that you are using the wildcard * in your append queries to select ALL fields from the source, local, tables to insert to the SQL Azure tables, and that includes the "ID" field, which is the AutoNumber (or in SQL Azure, the Identity). If the local "ID" is also called "ID" in the linked table, that's not going to work. SQL Azure is much tougher on unique values for Identity datatypes.
Instead, write the SQL to include SPECIFICALLY all fields except that "ID" field. Let SQL Azure generates its own unique Identity values. See if that works. If not, I'll dig into it this afternoon.