Working with poor named Access procedures
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 - Total
rptCost North & South
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.
(apologies for xpost)