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.

(apologies for xpost)

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

I dont understand why they are troubling you, nor what your problem is

Wind is your friend
Matt

The following code:

Set oCommand = Server.CreateObject("ADODB.Command")
Set oCommand.ActiveConnection = cn
    oCommand.CommandType = 4
    oCommand.CommandText = "rptCost Summary"
    Set rsData = oCommand.Execute

Leads to the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'rptCost'. Make sure it exists and that its name is spelled correctly.

Regards,

Sean Anderson

Try enclosing the name in square brackets:
oCommand.CommandText = "[rptCost Summary]"


Woody Z
http://www.learntoprogramnow.com