finkaboutit said:
how can I find out who is using my computor and how many tmes they are
logging on.
Go to Control Panel --> Administrative Tools --> Event Viewer; select
the Security folder, then use Action --> Save Log File As. Use
tab-delimited text format.
The Access text import wizard has trouble when, as in this case, text
records contain CR codes, so this won't work perfectly, but it might be
good enough for what you need. If not, you may want to write code to
reformat the text file before importing into Access. Assuming you don't
want to do that, the next steps are...
In Access, use File --> Get External Data --> Import. In the dialog
box, set the file type to Text Files, then navigate to where you saved
the log file.
Set the options for tab-delimited and double quotation marks, and
specify which fields you want to import; I'm guessing date, time, event,
and user ID. For the others, select the field and click "Do not import
field (skip)". You may need to change the format of the time-of-day
field from "Date/Time" to "Text", because Access may not like the format
of the time.
You'll likely get errors when you import the table. I suggest ignoring
those that involve the date field, as it's also used by the detail records.
You can use the following query to delete the records that don't start
with a date; I called that field "Field1":
DELETE Logons.Field1
FROM Logons
WHERE (((Logons.Field1) Is Null));
You might want to check the errors table to be sure that the only errors
were type conversions of the date, but then you can delete it.
The result is likely to contain the information you want. You can
filter it, sort it, put it into printed reports, etc.
-- Vincent Johns <
[email protected]>
Please feel free to quote anything I say here.
