Can I run an Insert Into and/or Delete queries (to a MSAccess database) from Frontpage code?

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

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.
==============================================
 
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
 
Back
Top