Database Interface Wizard - running existing update query

[Guest]

I have ( with the help of Kathleen & Paul) created a working Database
Interface. The Access database now sits on the server, and I can add,delete
and update records ok, using the Database Interface. So far so good......

Before, when the Access database was sitting on my pc, I was able to run an
update query, to update fields within the records, before publishing the
complete database to the server.

How do I run that same query on the database, which is now located on the
server please.

 

[Stefan B Rusynko]

Export the DB to your desktop, run your query, Import the DB back into the FP web (or on the server)

--




|I have ( with the help of Kathleen & Paul) created a working Database
| Interface. The Access database now sits on the server, and I can add,delete
| and update records ok, using the Database Interface. So far so good......
|
| Before, when the Access database was sitting on my pc, I was able to run an
| update query, to update fields within the records, before publishing the
| complete database to the server.
|
| How do I run that same query on the database, which is now located on the
| server please.

 

[Guest]

Thanks Stefan for the reply, and so quick too.
Is there any way I can run the update query from my pc to the DB on the
server without import/update/export procedure please
Mick

 

[Stefan B Rusynko]

Write a custom ASP page in your site to run the query (or equivalent action on your DB) from your site
- Not all Access queries are directly translatable to VBscript supported on a server

--




| Thanks Stefan for the reply, and so quick too.
| Is there any way I can run the update query from my pc to the DB on the
| server without import/update/export procedure please
| Mick
|
| "Stefan B Rusynko" wrote:
|
| > Export the DB to your desktop, run your query, Import the DB back into the FP web (or on the server)
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > |I have ( with the help of Kathleen & Paul) created a working Database
| > | Interface. The Access database now sits on the server, and I can add,delete
| > | and update records ok, using the Database Interface. So far so good......
| > |
| > | Before, when the Access database was sitting on my pc, I was able to run an
| > | update query, to update fields within the records, before publishing the
| > | complete database to the server.
| > |
| > | How do I run that same query on the database, which is now located on the
| > | server please.
| >
| >
| >

 

[Thomas A. Rowe]

You don't want to do this, as it would lock the database so site visitor would not be able
write/edit and data, also with the new security features in Windows XP SP2 you will be block from
open the Access database over the internet.

The workaround would be to create a page with your query, and then run it on your site from your
browser or make sure that your input query is writing the necessary values to the field when the
record is created or modified, so that it would not be necessary to run a update query.


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
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.
==============================================

 

[Guest]

Thanks Thomas, I think im now our of my depth with this one. Thanks again.

 

[Guest]

One more attempt, I'm trying not be beaten!
:The workaround would be to create a page with your
query, and then run it on your site from your browser"

Thomas, how do I do this please. The update query is in the "queries" in the
database, how do I bring it out to a new page to execute the query via the
browser.
thanks
Mick

 

[Thomas A. Rowe]

You have to learn to code ASP/VBScript.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
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.
==============================================

 

[Kathleen Anderson [MVP - FrontPage]]

When you are selecting the recordsource for your Database Results page, an
Access query will show up as View in the list.

--

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

 

[Guest]

Hi Kathleen, sorry been away for a week.
When selecting "record source" I can see all of my tables, and normal
queries, except the update queries, can you think of something I'm not doing
right.
Many thanks
Mick