I have an .asp site running FrontPage with an Access
database, currently about 3,000 records. The db is "view
only", users can search but can't make modifications -
however - I need to change the content in two fields that
have entries in every record. I'd like to make the mods in
Access and re-upload the .mdb - this is changing data
only, not structure, not format, only text.

Questions: Do I re-import the revised .mdb into my web and
then re-publish? Or can I just copy the revised .mdb into
my web and then re-publish? Anything else I should know?

TIA!

Just open the web live, double click the .mdb file to edit it in Access and
save.

--
David D Cowell
Wildcat Computers, Inc.
http://www.wildcatcomputers.net
800-686-4685
"Trillian" <(E-Mail Removed)> wrote in message
news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> I have an .asp site running FrontPage with an Access
> database, currently about 3,000 records. The db is "view
> only", users can search but can't make modifications -
> however - I need to change the content in two fields that
> have entries in every record. I'd like to make the mods in
> Access and re-upload the .mdb - this is changing data
> only, not structure, not format, only text.
>
> Questions: Do I re-import the revised .mdb into my web and
> then re-publish? Or can I just copy the revised .mdb into
> my web and then re-publish? Anything else I should know?
>
> TIA!
>
>

I don't know what you mean by "open the web live" - where
would I do this? As far as I know I can only access
the .mdb via the FP Editor...?

>-----Original Message-----
>Just open the web live, double click the .mdb file to
edit it in Access and
>save.
>
>--
>David D Cowell
>Wildcat Computers, Inc.
>http://www.wildcatcomputers.net
>800-686-4685
>"Trillian" <(E-Mail Removed)> wrote in
message
>news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
>> I have an .asp site running FrontPage with an Access
>> database, currently about 3,000 records. The db is "view
>> only", users can search but can't make modifications -
>> however - I need to change the content in two fields
that
>> have entries in every record. I'd like to make the mods
in
>> Access and re-upload the .mdb - this is changing data
>> only, not structure, not format, only text.
>>
>> Questions: Do I re-import the revised .mdb into my web
and
>> then re-publish? Or can I just copy the revised .mdb
into
>> my web and then re-publish? Anything else I should know?
>>
>> TIA!
>>
>>
>
>
>.
>

Open "www.yourweb.com" in FrontPage and find the .mdb file and double-click
it.

--
David D Cowell
Wildcat Computers, Inc.
http://www.wildcatcomputers.net
800-686-4685
"Trillian" <(E-Mail Removed)> wrote in message
news:d87d01c3ef3d$5a3bae10$(E-Mail Removed)...
> I don't know what you mean by "open the web live" - where
> would I do this? As far as I know I can only access
> the .mdb via the FP Editor...?
>
> >-----Original Message-----
> >Just open the web live, double click the .mdb file to
> edit it in Access and
> >save.
> >
> >--
> >David D Cowell
> >Wildcat Computers, Inc.
> >http://www.wildcatcomputers.net
> >800-686-4685
> >"Trillian" <(E-Mail Removed)> wrote in
> message
> >news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> >> I have an .asp site running FrontPage with an Access
> >> database, currently about 3,000 records. The db is "view
> >> only", users can search but can't make modifications -
> >> however - I need to change the content in two fields
> that
> >> have entries in every record. I'd like to make the mods
> in
> >> Access and re-upload the .mdb - this is changing data
> >> only, not structure, not format, only text.
> >>
> >> Questions: Do I re-import the revised .mdb into my web
> and
> >> then re-publish? Or can I just copy the revised .mdb
> into
> >> my web and then re-publish? Anything else I should know?
> >>
> >> TIA!
> >>
> >>
> >
> >
> >.
> >

When you do >File >Open Web, choose your URL (ie htttp:///www.domain.com) as
opposed to your local copy (ie c:\My Documents\My Webs\Domain.com)

Mike


"Trillian" <(E-Mail Removed)> wrote in message
news:d87d01c3ef3d$5a3bae10$(E-Mail Removed)...
> I don't know what you mean by "open the web live" - where
> would I do this? As far as I know I can only access
> the .mdb via the FP Editor...?
>
> >-----Original Message-----
> >Just open the web live, double click the .mdb file to
> edit it in Access and
> >save.
> >
> >--
> >David D Cowell
> >Wildcat Computers, Inc.
> >http://www.wildcatcomputers.net
> >800-686-4685
> >"Trillian" <(E-Mail Removed)> wrote in
> message
> >news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> >> I have an .asp site running FrontPage with an Access
> >> database, currently about 3,000 records. The db is "view
> >> only", users can search but can't make modifications -
> >> however - I need to change the content in two fields
> that
> >> have entries in every record. I'd like to make the mods
> in
> >> Access and re-upload the .mdb - this is changing data
> >> only, not structure, not format, only text.
> >>
> >> Questions: Do I re-import the revised .mdb into my web
> and
> >> then re-publish? Or can I just copy the revised .mdb
> into
> >> my web and then re-publish? Anything else I should know?
> >>
> >> TIA!
> >>
> >>
> >
> >
> >.
> >

Just export the database to your desktop. make your changes, then re-import
(drag/drop) it back into the fpdb folder, then publish.

It is not a good idea to open the database directly from within FP, as it is
open as a temp file in Access.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Trillian" <(E-Mail Removed)> wrote in message
news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> I have an .asp site running FrontPage with an Access
> database, currently about 3,000 records. The db is "view
> only", users can search but can't make modifications -
> however - I need to change the content in two fields that
> have entries in every record. I'd like to make the mods in
> Access and re-upload the .mdb - this is changing data
> only, not structure, not format, only text.
>
> Questions: Do I re-import the revised .mdb into my web and
> then re-publish? Or can I just copy the revised .mdb into
> my web and then re-publish? Anything else I should know?
>
> TIA!
>
>

Anytime you open any Office file it opens a temp file, whether from the
desktop or from a FP web. If the web site only "reads" the database and
doesn't write to it What's the problem?

--
David D Cowell
Wildcat Computers, Inc.
http://www.wildcatcomputers.net
800-686-4685
"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%23T60d%(E-Mail Removed)...
> Just export the database to your desktop. make your changes, then
re-import
> (drag/drop) it back into the fpdb folder, then publish.
>
> It is not a good idea to open the database directly from within FP, as it
is
> open as a temp file in Access.
>
> --
>
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle,
> MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Trillian" <(E-Mail Removed)> wrote in message
> news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> > I have an .asp site running FrontPage with an Access
> > database, currently about 3,000 records. The db is "view
> > only", users can search but can't make modifications -
> > however - I need to change the content in two fields that
> > have entries in every record. I'd like to make the mods in
> > Access and re-upload the .mdb - this is changing data
> > only, not structure, not format, only text.
> >
> > Questions: Do I re-import the revised .mdb into my web and
> > then re-publish? Or can I just copy the revised .mdb into
> > my web and then re-publish? Anything else I should know?
> >
> > TIA!
> >
> >
>
>

Thanks - I had NO idea you could do that...!

>-----Original Message-----
>Just open the web live, double click the .mdb file to
edit it in Access and
>save.
>
>--
>David D Cowell
>Wildcat Computers, Inc.
>http://www.wildcatcomputers.net
>800-686-4685
>"Trillian" <(E-Mail Removed)> wrote in
message
>news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
>> I have an .asp site running FrontPage with an Access
>> database, currently about 3,000 records. The db is "view
>> only", users can search but can't make modifications -
>> however - I need to change the content in two fields
that
>> have entries in every record. I'd like to make the mods
in
>> Access and re-upload the .mdb - this is changing data
>> only, not structure, not format, only text.
>>
>> Questions: Do I re-import the revised .mdb into my web
and
>> then re-publish? Or can I just copy the revised .mdb
into
>> my web and then re-publish? Anything else I should know?
>>
>> TIA!
>>
>>
>
>
>.
>

Thanks - I had NO idea you could do that...!

>-----Original Message-----
>Open "www.yourweb.com" in FrontPage and find the .mdb
file and double-click
>it.
>
>--
>David D Cowell
>Wildcat Computers, Inc.
>http://www.wildcatcomputers.net
>800-686-4685
>"Trillian" <(E-Mail Removed)> wrote in
message
>news:d87d01c3ef3d$5a3bae10$(E-Mail Removed)...
>> I don't know what you mean by "open the web live" -
where
>> would I do this? As far as I know I can only access
>> the .mdb via the FP Editor...?
>>
>> >-----Original Message-----
>> >Just open the web live, double click the .mdb file to
>> edit it in Access and
>> >save.
>> >
>> >--
>> >David D Cowell
>> >Wildcat Computers, Inc.
>> >http://www.wildcatcomputers.net
>> >800-686-4685
>> >"Trillian" <(E-Mail Removed)> wrote
in
>> message
>> >news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
>> >> I have an .asp site running FrontPage with an Access
>> >> database, currently about 3,000 records. The db
is "view
>> >> only", users can search but can't make
modifications -
>> >> however - I need to change the content in two fields
>> that
>> >> have entries in every record. I'd like to make the
mods
>> in
>> >> Access and re-upload the .mdb - this is changing data
>> >> only, not structure, not format, only text.
>> >>
>> >> Questions: Do I re-import the revised .mdb into my
web
>> and
>> >> then re-publish? Or can I just copy the revised .mdb
>> into
>> >> my web and then re-publish? Anything else I should
know?
>> >>
>> >> TIA!
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>

When you open it from within FP, it is open the FP temp directory, with a
call to the Access application, which uses more memory/resources. Second
issue, the database does not actually get updated in the web until you have
actual close the Access application, not just the database. And if you have
any type of connection/network problems or other glitches, you will render
your database un-useable.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"David D Cowell" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Anytime you open any Office file it opens a temp file, whether from the
> desktop or from a FP web. If the web site only "reads" the database and
> doesn't write to it What's the problem?
>
> --
> David D Cowell
> Wildcat Computers, Inc.
> http://www.wildcatcomputers.net
> 800-686-4685
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%23T60d%(E-Mail Removed)...
> > Just export the database to your desktop. make your changes, then
> re-import
> > (drag/drop) it back into the fpdb folder, then publish.
> >
> > It is not a good idea to open the database directly from within FP, as
it
> is
> > open as a temp file in Access.
> >
> > --
> >
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle,
> > MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Trillian" <(E-Mail Removed)> wrote in message
> > news:d83b01c3ef39$aeeb81f0$(E-Mail Removed)...
> > > I have an .asp site running FrontPage with an Access
> > > database, currently about 3,000 records. The db is "view
> > > only", users can search but can't make modifications -
> > > however - I need to change the content in two fields that
> > > have entries in every record. I'd like to make the mods in
> > > Access and re-upload the .mdb - this is changing data
> > > only, not structure, not format, only text.
> > >
> > > Questions: Do I re-import the revised .mdb into my web and
> > > then re-publish? Or can I just copy the revised .mdb into
> > > my web and then re-publish? Anything else I should know?
> > >
> > > TIA!
> > >
> > >
> >
> >
>
>