Hi All,
I'm trying to update a value in an SQL Server linked table on insert of a value into an Access table in my linked back end. I've setup an after insert macro on my Access back end table which calls a function to update the linked SQL Server table using DoCmd.RunSQL.
This works absolutely fine as long as I type or paste the value into my Access table. If I try to append the value using an append query in Access I get the run-time error message 2486: "You can't carry out this action at the present time" and the DoCmd.RunSQL line is highlighted.
I'd be grateful for any suggestions anyone can offer.
Thanks,
Matthew
I'm trying to update a value in an SQL Server linked table on insert of a value into an Access table in my linked back end. I've setup an after insert macro on my Access back end table which calls a function to update the linked SQL Server table using DoCmd.RunSQL.
This works absolutely fine as long as I type or paste the value into my Access table. If I try to append the value using an append query in Access I get the run-time error message 2486: "You can't carry out this action at the present time" and the DoCmd.RunSQL line is highlighted.
I'd be grateful for any suggestions anyone can offer.
Thanks,
Matthew