Hey there, can anyone advise if the following is possible and if so how it
might be done?

I have created a site using DWMX04, ASP & ACCESS.

I would like to be able to have some sort of report on what is being searche
d
on the database.

Can this be done in ACCESS or by using ASP?

Any ideas or suggestions would be great.

Mally.

> I have created a site using DWMX04, ASP & ACCESS.

Good information.
So your site is remotely hosted on an ASP-enabled server?

Your web page connects to the database on the host?

Got a URL?

> I would like to be able to have some sort of report on what is being
> searched
> on the database.

Can you outline your vision in a series of steps?

You want to know what is being read from the database?

What info do you want?

> Can this be done in ACCESS or by using ASP?

Probably. See above.

--
Regards

John Waller

Hey there, my site is not hosted yet but will be in the next week or two. Th
e
site will mostlikely be hosted on a server that supports ASP as it is the on
ly
language I am remotley familiar with.

All I am looking for is some sort of report on what items are being searched
on the Access database.

A good exaple is we have 50 types of cloth on a database. We just want know
know how many times each cloth detail was called up. This would give us a go
od
idea on what cloth is more popular.

Information can be simply just a column in the database or even a asp file o
n
the web which the admin department can view at any time.

Nothing too flash, just looking for a number realy.

Cloth A    Searched 54 times
Cloth B    Searched 01 times

Etc.

Mally

Also, who searched and when they searched would be good to but not realy nec
cesary.

Also, who searched and when they searched would be good to but not realy nec
cesary.

MalRom wrote:
> Also, who searched and when they searched would be good to but not realy n
eccesary.
>

Hi

You could grab the search form value and insert the value into the
database. Once in the database you can use Distinct and Count to tot up
the information from the database.

This tutorial should help with the totals, the addition of the search
info should be straight forward, it would just be a basic insert of the
search form values, asp isn't my bag so I'm not 100% sure of the syntax
for the value checking.

http://www.communitymx.com/content/...e.cfm?cid=88C8C

--
Cheers jojo
Team Macromedia Member Volunteer for Dreamweaver 8
http://www.webade.co.uk
http://www.cmsforbusiness.co.uk
----------------------------------------------------
Extending Knowledge, Daily.
http://www.communityMX.com/
Free 10 day trial
http://www.communitymx.com/joincmx.cfm
----------------------------------------------------

>Also, who searched and when they searched would be good to but not realy
neccesary.

You are basically in need of an audit database. Your criteria is simple
enough. Just create a table to store the info you want to audit, and then as
JoJo suggests, insert a row when the user hits the search button. The row wi
ll
include the user id and search criteria. The table can be setup in access wi
th
a timestamp column that automatically logs the time, so no need to worry abo
ut
that in ASP.