|
Home > Archive > Microsoft SQL Server forum > May 2005 > log-file for interface-use
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
log-file for interface-use
|
|
| Filips Benoit 2005-05-30, 7:23 am |
| Dear All,
SQL-SERVER-DB
Access interface
25 users
I want to know how the users are working with the interface:
* What forms the use
* What routines the run ( commandbuttons)
* How long they use the interface
* etc.
I'll use a public function to add the information.
Where should i store the information ? :
* in a table in the SQL-DB: 1 table for all users on the server
* a text-file for each user on the users computer.
What solutions is the quickest?
Thanks,
Filip
| |
| Simon Hayes 2005-05-30, 7:23 am |
| I don't know much about Access, but I would suggest you use a database
table (or tables) to store your log, if possible. If you go with the
files, you'll have to collect them from each PC and then you'll
probably want to load them into the database anyway in order to do
reporting and generate summaries. The database table also gives you
'real-time' reporting, and you don't have to worry about users
accidentally deleting their log files.
Simon
|
|
|
|
|