Access 2007 - Export to ASP

[ladyck3]

I posted this in the ASP forum and then wondered if it really belonged here so I'm reposting it here.


I am having trouble with some ASP code, I'm getting an error regarding too many parameters.... I did a google search and it lead me to a MSKB article (for an earlier version of Access) and it says to File > Export the query as ASP.

In Access 2007 there is an option to export "More" but ASP is not listed on the options.

Does anyone know if this is possible in 2007?

Thanks!



LadyCK3
aka: Laurie

 

[Remou]

Too many parameters suggests that you need to check your SQL statement. You should be able to cut and paste simple queries from the query window, but you are probably better writing them yourself.

 

[ladyck3]

I figured out the problem, my ASP code had a correct field name, but I had it (dislexic) transposed in the database ::SIGH::

Anyway, I'm editing code written FOR ME... not BY ME... and I thought, heck if ACCESS can export the queries that I have created, and working... in ACCESS to ASP, that might help me to produce the rest of this project in ASP w/o having to depend on others to help me with an area where I exhibit a bit of ignorance... ASP Code Writing

Thanks....

LadyCK3
aka: Laurie