JefB
Programmer
- Dec 29, 2000
- 56
I use a FrontPage2K .asp page to give users access to specific reports.
I do this by using the standard database results table requiring the user to enter a "clientID", "projectID" and password. This links to a SQL7 view (query) that, if the 3 fields match records in the query, displays a database result table of available reports with each report name hyperlinked to a separate report page.
That works fine; however, I would like to add something that will automatically write the three fields to a log table (without user intervention) so that we can track usage.
Can someone suggest a component or add-in that I can use. We are not programmers (other than basic HTML) so simplicity is a must!
Thanks
JefB
I do this by using the standard database results table requiring the user to enter a "clientID", "projectID" and password. This links to a SQL7 view (query) that, if the 3 fields match records in the query, displays a database result table of available reports with each report name hyperlinked to a separate report page.
That works fine; however, I would like to add something that will automatically write the three fields to a log table (without user intervention) so that we can track usage.
Can someone suggest a component or add-in that I can use. We are not programmers (other than basic HTML) so simplicity is a must!
Thanks
JefB