Re: Delete Procedure in Access Database from asp.
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 15:56:18 -0500
GrandMaMa wrote:
> After some time I have been able to create a query from an asp Page.
> Several individuals have recommended several sites all of which did
> not work when I tried their examples or suggestions.
>
> The following code after six hours of guessing does not work.
:-)
Why guess? look up the proper syntax in Access online help. Step by step:
open Access
Press F1 if Help isn't already displayed
Find and click the Table of Contents Link
Expand the Microsoft Jet SQL Reference node
Expand the Data Definition Language node
Start reading ;-)
Look for the DROP statement node
>
> cnnct.execute "Delete Proc qryWebTest"
It's "DROP PROCEDURE", not "Delete Proc"
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Prev by Date: Re: winsock?
- Next by Date: Re: obtaining the drive letter that triggered AutoPlay
- Previous by thread: obtaining the drive letter that triggered AutoPlay
- Next by thread: Re: Delete Procedure in Access Database from asp.
- Index(es):
Relevant Pages
|
|
