Hi everyone,
I have the strangest of problems: I have an Access database that runs an update query containing a JOIN between a remote SQL Server table and a local Access table. The primary key is a uniqueidentifier field (GUID). The update query runs just fine on regular Access, but fails on runtime Access:
Error 3157, update on a linked table failed - invalid character value for cast specification
I have tried A LOT of different things (for about a week now...). Can anyone put me on the right track?
Your help is much appreciated.
Greetings from Holland,
Keimpe Wiersma
I have the strangest of problems: I have an Access database that runs an update query containing a JOIN between a remote SQL Server table and a local Access table. The primary key is a uniqueidentifier field (GUID). The update query runs just fine on regular Access, but fails on runtime Access:
Error 3157, update on a linked table failed - invalid character value for cast specification
I have tried A LOT of different things (for about a week now...). Can anyone put me on the right track?
Your help is much appreciated.
Greetings from Holland,
Keimpe Wiersma