Hi,

I defined a query in Access.
I created a AccessDataSource in an aspx page using Visual Web Developer.
I specify Access, oledb etc ... and in the window "how do you like to
retrieve data from db?"
i choose "specify a custom sql or stored procedure".
I go to next, but here, the radio input of "stored procedure" is not
enabled.

How can i specify a stored procedure?
Thanks for help

I am definitely not an expert by any means, but I don't think Access classifies the queries as Stored Procedures. What might work in this case, if in the Access Query, go to the SQL view for the query, and then use that SQL to use the Custom SQL option.

HTH

Mike

Mike
EchoVue.com

Thanks

By my knowledge it's not possible to use stored procedures when working with an MS Access back-end database.
grtz,
Jouri

I'd like to recall my last message.
Indeed it's possible to create stored procedures in MS Access. See article on: http://www.devcity.net/Articles/18/msaccess_sp.aspx
grtz,
Jouri