I've a database which I'm currently setting up user accounts for. My application is quiet large and I need to construct a process by which I can account for all the changes that a particular user makes to dat within any of the tables? Any one have any ideas on this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Teacking changes to MS Access DB
- Thread starter shane01
- Start date
thornmastr
Programmer
This article and code will probably help you.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
MichaelRed
Programmer
Somewhat dated, faq181-291
You need to have/enforce strict security on Ms. A, since there are no table level triggers. You can only 'detect' changes to bound objects. To be able to enforce changes via forms, user security needs to restrict users from any access to data except through the forms.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
You need to have/enforce strict security on Ms. A, since there are no table level triggers. You can only 'detect' changes to bound objects. To be able to enforce changes via forms, user security needs to restrict users from any access to data except through the forms.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question