Hello...
Is there any possibilities for Microsoft Access to create log files activity?
Is there any possibilities for Microsoft Access to create log files activity?
-
-
That depends on what version of access you have, what kind of activity you want to log, and how comfortable you are with a lot of coding. -
thnks for replying @Rabbit .....the activity such as when user delete items...when user log in and log out...and then we can save the log acttivity...acc ess can do all that?Comment
-
You still need to answer my other two questions in the prior post.Comment
-
ACCESS 2010....and actually I'm still new in access....Comment
-
In access 2010, you can use the new data macro functionality to capture activity on a table such as the deleted you want to capture. For more info on data macros, here is a link to Microsoft's manual: https://support.office.com/en-nz/art...d-f296ef834200
For log in and log out, you will need to specially code a form for that. Do a search in the forum, there are plenty of threads that discuss this issue. And since you're new to access, you might want to do a tutorial on VBA before taking on a project of this size.Comment
-
Thnks for replying @Rabbit....does vba and query can work together? Seems I try combine vba with query...just want to know does it work?Comment
-
You can run queries from VBA. But running a query from VBA does not identify deletes because if it's deleted, there's nothing to query. You need to use the previously mentioned data macros for that.Comment
Comment