MS Access database support - ADP frontend - How to update a row added by a trigger

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ADP frontend - How to update a row added by a trigger

VivN

2005-06-29, 7:24 am

I have been setting up an Access ADP front end with SQL server back
end.
I have defined triggers on some tables to audit changes to these
tables.
When a row is deleted, I need to record who requested the change.
I have created a procedure that will do this and it works sucessfully
if I test it from the from end by calling the stored procedure directly
from the database window for an existing record.

However, when the procedure gets called at run time using an ADODB
command, the row is not getting updated.
I have checked if the new row is visible from the front end when the
procedure is called, and have found that it is not there.

Is there a command that will force a requery of the table without
having to close and reopen the connection?

VivN

Sponsored Links