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.

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
_____________________________________________


"Mick" <(E-Mail Removed)> wrote in message news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
|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.

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
> _____________________________________________
>
>
> "Mick" <(E-Mail Removed)> wrote in message news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
> |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.
>
>
>

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

--

_____________________________________________
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
_____________________________________________


"Mick" <(E-Mail Removed)> wrote in message news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
| 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
| > _____________________________________________
| >
| >
| > "Mick" <(E-Mail Removed)> wrote in message news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
| > |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.
| >
| >
| >

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)
http://www.ycoln-resources.com
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.
==============================================

"Mick" <(E-Mail Removed)> wrote in message
news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
> 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
>> _____________________________________________
>>
>>
>> "Mick" <(E-Mail Removed)> wrote in message
>> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
>> |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.
>>
>>
>>

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


"Thomas A. Rowe" wrote:

> 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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "Mick" <(E-Mail Removed)> wrote in message
> news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
> > 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
> >> _____________________________________________
> >>
> >>
> >> "Mick" <(E-Mail Removed)> wrote in message
> >> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
> >> |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.
> >>
> >>
> >>
>
>
>

One more attempt, I'm trying not be beaten!
"Thomas A. Rowe" wrote: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" wrote:

> 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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "Mick" <(E-Mail Removed)> wrote in message
> news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
> > 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
> >> _____________________________________________
> >>
> >>
> >> "Mick" <(E-Mail Removed)> wrote in message
> >> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
> >> |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.
> >>
> >>
> >>
>
>
>

You have to learn to code ASP/VBScript.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
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.
==============================================

"Mick" <(E-Mail Removed)> wrote in message
news:585C3C1A-5944-4BFE-86D9-(E-Mail Removed)...
> One more attempt, I'm trying not be beaten!
> "Thomas A. Rowe" wrote: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" wrote:
>
>> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "Mick" <(E-Mail Removed)> wrote in message
>> news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
>> > 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
>> >> _____________________________________________
>> >>
>> >>
>> >> "Mick" <(E-Mail Removed)> wrote in message
>> >> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
>> >> |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.
>> >>
>> >>
>> >>
>>
>>
>>

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


Mick <(E-Mail Removed)> wrote:
> One more attempt, I'm trying not be beaten!
> "Thomas A. Rowe" wrote: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" wrote:
>
>> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "Mick" <(E-Mail Removed)> wrote in message
>> news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
>>> 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
>>>> _____________________________________________
>>>>
>>>>
>>>> "Mick" <(E-Mail Removed)> wrote in message
>>>> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
>>>>> 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.

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

"Kathleen Anderson [MVP - FrontPage]" wrote:

> 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
>
>
> Mick <(E-Mail Removed)> wrote:
> > One more attempt, I'm trying not be beaten!
> > "Thomas A. Rowe" wrote: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" wrote:
> >
> >> 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)
> >> http://www.ycoln-resources.com
> >> 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.
> >> ==============================================
> >>
> >> "Mick" <(E-Mail Removed)> wrote in message
> >> news:E4DF3B6F-F532-452C-BE38-(E-Mail Removed)...
> >>> 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
> >>>> _____________________________________________
> >>>>
> >>>>
> >>>> "Mick" <(E-Mail Removed)> wrote in message
> >>>> news:890D2EF4-79D4-43AD-94D2-(E-Mail Removed)...
> >>>>> 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.
>
>