Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement