It doesn't appear in the Query tab in Access.
I have access to the mdb file, but users of our intranet do not. The reason
for needing to create queries is a long story. It's also quite difficult to
explain. It may not even be the ideal solution (Bob's posts on
parameterised queries have got me thinking...), but it's one that could
work.
I could try to explain off list. If you manage to a) read through the whole
scenario (which will be long!) and b) think it's acceptable to make it a
post, I'd post it to the group as a whole.
Morris
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:O6**************@tk2msftngp13.phx.gbl...
You should see it in the query collection in Access.
Mind if I ask why you're creating "stored procedures" this way? Do you
not
have access to the Access file?
Ray at work
"Morris" <us**@domain.com> wrote in message
news:38*************@individual.net... I've created a procedure/query in an Access 2000 database using the
following code:
<%
strAppend = "ProcName"
strSQL = "Create Procedure [qry" & strAppend & "] AS Select * From
Stories
ORDER BY StoryID DESC;"
cn.execute(strSQL)
%>
I know I have successfully created the procedure/query, because when I
run
the code again, it gives me the following error:
Microsoft JET Database Engine (0x80040E14)
Object 'qryProcName' already exists.
I look in the Access database and can't find qryProcName as a query,
macro
or any other object. How do I access it?
Morris