|
AccStats is a small free Microsoft Access database program for people that
use the Fluid Dynamics
free AXS perl script for tracking website traffic and hits.
AccStats can be used to query, convert, import, export and keep a master
database of all hits in the AXS log.txt file.
You can also use this utility to create nicely formatted, printable reports
through the standard Microsoft Access report module.
Requirements
Microsoft Access 97 or 2000.
If you are using Access 2000... you must add a reference to the DAO 3.5 object
library by simply clicking on one checkbox within Access, see the Microsoft
Knowledge Base article Q202192 for instructions.
Failing to do this will result in errors like: "Compile error: Can't find
project or library" or "User defined type not recognized" etc.
Tested with AXS Script Set Versions:
2.3.0.0010 to 2.3.0.0016
Key Benefits
- Import - Import Axs log.txt file. AccStats ensures not duplicate hits
can be imported so it's safe to import any log at any time.
- Export - Export to comma separated text, html or back to Axs format for
the entire database or select a specific date range.
- Enter and keep track of spiders - AccStats comes with a list of 327
known spiders, you can easily add to or edit this list. This list is used in
queries to show things like most recent visit by each unique spider etc.
- Queries - There are many queries that come with AccStats and you can
easily add your own. There are 17 different queries that come with this
release.
Support
AccStats is released as is.
As a free utility, we do not provide any support
Acknowledgements
Thank you to Zoltan for permission to publish this utility and for help with
the AX-Stats logfile format.
Download
Version 1.0 Access 97 version
setup.exe
Version 1.0 Access 2000 version
setup2k.exe
| 
