To ALL;

I've created a remote view to an access table. I've created an index in the table (id) and I allow duplicates on this index. In the update criteria, I have NOT forgotten to select the "Send SQL Updates" and I allow all the fields to be updated. I have "Set Multilocks ON" and the buffering status is set to 5. Through the browse and command window I and able to edit a record with issue BUT I an not able to add. The =tableupdate() command returns an array with the "-1" result.

Through the form that I am using, I am not even able to edit the record never mind Add one on.

Through this same connection I am able to update, add and delete records in the other tables. Other than field names, we have structured them the same.

Any clues about where I should be looking for the problem??

Thanks

Sandy