I have a form, with a linked-table as its data source. When the user clicks a button, an ADODB.Command is built for the appropriate stored procedure (add/update/delete).
I am using ADO and the command object so that I can get the autonum primary key field after an add.
Here's the problem: After adding a record, I get the "Write Conflict" error and I can only choose the second two options - clipboard or drop changes.
The update went through, but when I come back to the record, various fields have been padded on the right. For instance, one of the fields is defined on SQL Server as nvarchar(255). It only has about 25 characters in it, but it comes back padded to probably 255.
I really don't know what is going on. Any help is appreciated.
I am using ADO and the command object so that I can get the autonum primary key field after an add.
Here's the problem: After adding a record, I get the "Write Conflict" error and I can only choose the second two options - clipboard or drop changes.
The update went through, but when I come back to the record, various fields have been padded on the right. For instance, one of the fields is defined on SQL Server as nvarchar(255). It only has about 25 characters in it, but it comes back padded to probably 255.
I really don't know what is going on. Any help is appreciated.
