Dear all
Can I run an Insert Into and/or Delete queries (to a MSAccess database) from
Frontpage code?
I can run Select queries from code and can run Insert Into and Delete
functions using the Database Results Wizard but I want to be able to insert
rows into a table as each cycle of a loop (that is written in code)
executes.
Does anyone know a way to do this?

Thanks for any advice. Alan

You would have to custom write the insert into script.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Alan" <(E-Mail Removed)_NO_SPAM> wrote in message news:42d271b9$(E-Mail Removed)...
> Dear all
> Can I run an Insert Into and/or Delete queries (to a MSAccess database) from Frontpage code?
> I can run Select queries from code and can run Insert Into and Delete functions using the Database
> Results Wizard but I want to be able to insert rows into a table as each cycle of a loop (that is
> written in code) executes.
> Does anyone know a way to do this?
>
> Thanks for any advice. Alan
>
>
>

If you are running FrontPage 2002 or 2003, you can use the FrontPage
Database INterface Wizard to do this.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/




"Alan" <(E-Mail Removed)_NO_SPAM> wrote in message
news:42d271b9$(E-Mail Removed)...
> Dear all
> Can I run an Insert Into and/or Delete queries (to a MSAccess database)
> from Frontpage code?
> I can run Select queries from code and can run Insert Into and Delete
> functions using the Database Results Wizard but I want to be able to
> insert rows into a table as each cycle of a loop (that is written in code)
> executes.
> Does anyone know a way to do this?
>
> Thanks for any advice. Alan
>
>
>

Dear Kathleen and Thomas

Thank you for your replies. For reasons which I don't understand I have now
got it to work using VB code. I noticed that when I wrote the VB code in
Frontpage, published it and then looked at it on Internet Explorer I got a
different result (ie it worked versus didn't work) if I initially just
refreshed the asp page, rather than call it up from a hyperlink from the
index.html file. Presumably refreshing does not call up the underlying code
from the server. Anyway it is now working and I thank you for your help.

Cheers...Alan


"Alan" <(E-Mail Removed)_NO_SPAM> wrote in message
news:42d271b9$(E-Mail Removed)...
> Dear all
> Can I run an Insert Into and/or Delete queries (to a MSAccess database)
> from Frontpage code?
> I can run Select queries from code and can run Insert Into and Delete
> functions using the Database Results Wizard but I want to be able to
> insert rows into a table as each cycle of a loop (that is written in code)
> executes.
> Does anyone know a way to do this?
>
> Thanks for any advice. Alan
>
>
>