Action Query in Access

[Poppy]

Can anyone tell me if it is possible to execute an access action query from
asp/vbscript code?

TIA

[Ray at]

Yes it is.

Ray at work

"Poppy" <paul.diamond@NOSPAMthemedialounge.com> wrote in message
news:%2353U1B$lDHA.2528@TK2MSFTNGP10.phx.gbl...

> Can anyone tell me if it is possible to execute an access action query

from

> asp/vbscript code?
>
> TIA
>
>

[Bob Barrows]

Poppy wrote:

> Can anyone tell me if it is possible to execute an access action
> query from asp/vbscript code?
>
> TIA

Yes.

cn.Open "valid connection string"
cn.NameOfQuery

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Adrian Forbes [ASP MVP]]

Best way of doing this is via the connection object

set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open MyConnectString
objCon.Execute "update table...."
objCon.Close

You can also call action queries via .Execute;

objCon.Execute "MyActionQuery"

"Poppy" <paul.diamond@NOSPAMthemedialounge.com> wrote in message
news:%2353U1B$lDHA.2528@TK2MSFTNGP10.phx.gbl...

> Can anyone tell me if it is possible to execute an access action query

from

> asp/vbscript code?
>
> TIA
>
>