J
JG
I cannot Add new records to a table, although I can edit
and update a select query fromm the table with no
difficulties.
Within Access VBA
The table is opened thus:
Set rst = ConLabels.OpenRecordset("dbo.LABELS",
dbOpenDynamic, 0, dbOptimistic)
with rst
.addnew
:::::
.update
falls over at the update line, even with just one field
completed, with error no 3146 odbc call failed
Why can I edit and update but not add and update?
Any Ideas anyone
and update a select query fromm the table with no
difficulties.
Within Access VBA
The table is opened thus:
Set rst = ConLabels.OpenRecordset("dbo.LABELS",
dbOpenDynamic, 0, dbOptimistic)
with rst
.addnew
:::::
.update
falls over at the update line, even with just one field
completed, with error no 3146 odbc call failed
Why can I edit and update but not add and update?
Any Ideas anyone