I am working with an Access application and have a large number of stored procedures that have been written (primarily) for use within Access and have been named in a variety of ways. This is troubling with ASP as I am getting errors...

oCommand.CommandText = <sp_name>

Where <sp_name> is like some of the following. They're being seen as whatever is read up to the non [A-Z/0-9] character, like "rptCost" fo rthe first three and "rptCost2006" for the last.

rptCost Summary
rptCost - Total
rptCost North & South
rptCost2006/2007

My question would be is there a way in which I can use the stored procedures, as they are? This would save renaming them all and recoding the content of the Access application and as there are literally hundreds of them in many applications would save an inordinate amount of time.

Many thanks.

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson