Use Enterprise Manager, go to Management, Current Activity, Process Info.  This will provide a list of all the process id's currently active in the system and the users and databases...

C:\MSSQL\LOG

Depends on the path of where you have SQL installed...the above path would be the most basic path.

Try using the following line of code:

rsFoodCount.Open cmnd

in place of the following line:

Set rsFoodCount = cmnd.Execute

I believe the problem is that your parameters are not being created properly.  Try using the following lines of code in place of the two "cmnd.Parameters" lines of code in VB example:

cmnd.Parameters.Append...

I have experienced a similar problem with a maintenance plan while using SQL7.  The only way I could remedy the issue in 7 was to recreate the maintenance...