By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
How are you showing the data in the front end? datagrid, listbox?

Nov 13 '05 #2

P: n/a
The audit data is not viewed from the same form that generated the
audit record.
I opened the audit table from the ADP database window to check if the
new record was visible.
I just realised that I am trying to update the record from within the
FormDelete event - I guess the new row won't exist until the event has
completed.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.