Hello All:
I have a linked table from SQL Server 2000 into Access97. When trying to update the data with the recordselector in a form I get a 306 Error "Cannot update without using IS NULL or LIKE operators". I have no clue as how to set the recordsetclone to use those operators. If I create the sql statement and execute it works, the problem is that I'm converting tables and the forms are already create, it is huge to make the change if I have to do it for the many forms in this application.
Any idea will be great.
Thank you,
HAH
I have a linked table from SQL Server 2000 into Access97. When trying to update the data with the recordselector in a form I get a 306 Error "Cannot update without using IS NULL or LIKE operators". I have no clue as how to set the recordsetclone to use those operators. If I create the sql statement and execute it works, the problem is that I'm converting tables and the forms are already create, it is huge to make the change if I have to do it for the many forms in this application.
Any idea will be great.
Thank you,
HAH
