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

Perform Audit Trail in Access to Record Changes via Query

P: 6
Hi all!
Recently i need to urgently perform an audit trail for my newly built system. I have gone thru many threads about using trackchanges() function at beforeupdate to record the changes made in the form. However this method works well only when the changes is made directly thru forms.

In my system, user can make the changes either by entering data directly or through clicking buttons with queries, how can i also track the changes made by queries? Thanks a lot!
Oct 29 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
The only solution will be to switch to another database engine, like Oracle or MS SQL that will allow StoredProcedures to be executed on datamanipulation queries.
The Access database engine (Jet-engine) doesn't provide this possibility.

Sorry for the bad news....

Oct 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.