pause using ASP or MS Access?

I see the following only works in SQL Server?
'conn.Execute "WAITFOR DELAY '00:00:01'"
Is there a version of this that works in MS Access 2003?
If not, do any of you have a server-side way to pause?
Thanks!

--
Scotter

Re: pause using ASP or MS Access?

Scotter wrote:
> I see the following only works in SQL Server?
> 'conn.Execute "WAITFOR DELAY '00:00:01'"
> Is there a version of this that works in MS Access 2003?

No.

> If not, do any of you have a server-side way to pause?
http://www.aspfaq.com/show.asp?id=2141

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.

Re: pause using ASP or MS Access?

Thanks, Bob.
I don't think the "WAITFOR DELAY" works in MS Access... ?

"Bob Barrows [MVP]" wrote in message
news:eyV%23dpm1EHA.3000@TK2MSFTNGP15.phx.gbl...
> Scotter wrote:
>> I see the following only works in SQL Server?
>> 'conn.Execute "WAITFOR DELAY '00:00:01'"
>> Is there a version of this that works in MS Access 2003?
>
> No.
>
>> If not, do any of you have a server-side way to pause?
> http://www.aspfaq.com/show.asp?id=2141
>
> 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.
>
>

Re: pause using ASP or MS Access?

> I don't think the "WAITFOR DELAY" works in MS Access... ?

No, that's SQL Server only.

Re: pause using ASP or MS Access?

Why do you want to delay your server script execution?

Re: pause using ASP or MS Access?

> Why do you want to delay your server script execution?

I have no idea; I didn't post the question. Maybe you meant to reply to the
original poster.

Re: pause using ASP or MS Access?

Content Management System.
Allows creation of web pages and newsletters.
Has registration page where users can check "send me newsletter"
Has feature for admin to say "send newsletter link to all users who checked
that box"
What if 5000 users? I don't want my email server pounded that hard so I'd
like to build in a bit of a pause in the loop that is going thru the user
database and sending email out each iteration.

"Scotter" wrote in message
news:%SNqd.52383$KQ2.44893@fe2.texas.rr.com...
>I see the following only works in SQL Server?
> 'conn.Execute "WAITFOR DELAY '00:00:01'"
> Is there a version of this that works in MS Access 2003?
> If not, do any of you have a server-side way to pause?
> Thanks!
>
> --
> Scotter
>