General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How can I re-structure this user tracking feature?
In my master base form, in the load() event, I open a table called "Tracker", then I make a new record of the user name, date time, form name, and action(s) (add, edit, preview, print, etc) they make while using the form. I can then see who did what and when. Kind of a Big Brother thing. I usually purge off records older than two weeks.
Anyway, all my forms are modeless, and have their own private datasession, so a user can have about three or four forms open at once, and each one opens it own copy of "Tracker". Since all I do is append new records, I am wanting to only open one copy of Tracker in some central area.
Basically, I do not know how to write to a table outside of the current private datasession, and are there any drawbacks to this. ALl other tables must stay in the private datasession.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only