Problem solved....

I have creates a stored procedure to check the sysprocesses against the Workstation ID table and scheduled this to run every 10 mins (a bit excessive but it stops...

looking at the snippet of code it looks as though you are embeding your asp within html..

try this

copy the bit below and save as test.asp

...

We have a similar situation here with departments writing their own access applications and then the person responsible leaves...

it then falls on the IT department / DBA to pick up...

The way i check for the mdac version is by doing the following

copy the code below into notepad

dim oConn

set oConn=CreateObject("ADODB.Connection")

msgbox "Mdac Version = " & oConn.version

set oConn = nothing

save it...

It would also be usefull for those who had bought the software to make others aware of its limitations within SQL i.e. requiring the user to know the SA password...

You could also use crystal reports from within VB (see the crystal decisions website), but beware!! there are issues with licenses if you want to publish these reports on the...

Well I think I have got to the bottom of our disk thrashing problem...

The problem did not occur at all on friday..No changes have been made to the server..

The...

Vladan,mdamera, e.t.c

Out of interest

How many databases, What sizes , and how many transactions per second...

This information would be of some help in proving my case if push comes to shove.....

quote:

---

if you listen carefully) hear the satisfying thud of leather on ass of the individual concerned

---