Hi again,
I have figured out that my problem was not with the code above. It is due to the fact that the append query stored in Access contains the "*" wildcard on a string field.

So, now I am figuring out how to modify the wildcard so it can stay in the query, or conversely, how to successfully pass it in. I know I need to use the "%" so at least I'm part way there. If I get stumped on that, I will post to...

Hi dccoyne67,

I just had to figure this out myself, and with Company names, so I am happy to share how I managed it.
I did get a little lost in your code so I decided to just tell you how I do it and you can apply it to your specific situation.

Disclaimer: as I have a BBA in Information Management Systems from WAY long ago, but am self-taught for ASP, this may not be the BEST way, but it worked for me. If anyone...

Hi All,

I am at my wits end. I would consider myself an intermediate programmer and have been managing a web application that I wrote in .ASP, VBScript, and JavaScript for years. There is one task I cannot seem to get to work and that is to have ASP execute a stored procedure that is is an append query living on an MS Access backend.

I've worked around this issue by just opening the table then executing .AddNew, feeding...