I am writing a query to an SQL server linked table. I want to run a simple delete statement. The problem is i get an error saying "Must Use dbseechanges with openrecordset when accessing a table from an sql table using the IDENTITY column".
I do not have any problems viewing or adding records into this table.
I have checked ALL of my SQL documentation and can't find this anywhere.
Has anyone come across this before and/or knows what to do?