I have a large website maintained on local PC and published to my ISP. I
have recently upgraded to FP2003.

I wish to create an Access database from scratch (which will need frequent
updating). The database is only required for the website. I am finding the
online help pages unhelpful - maybe because I can't find the right pages..

Can anyone help with the following (or point me to the appropriate help
file):
Where is the best place to create the database?
Can I manipulate the database after it has been attached to FP (eg can I add
fields, tables etc.)?

novus

Yes, just create your database in access, then import into FP, FP will
prompt you create connection and then to place the database in the fpdb
folder, let it!

The use the FP database component to connect to the database using the
connection info you provided when you imported the database to display the
content of the database in your pages.

If the database is going to allow users of your site to add content, then
you will need to create admin page to manage the database directly on the
live site, otherwise unless you want to shut your site down, then download
the database and make change, then upload again so that you do not over
write any new content.

If the database will just be used to supply data to the site, then export
the database from your local FP web to your desktop, make your changes,
re-import and then publish.

Avoid edit your database directly from within FP by double-click it, etc. as
this can result is the file becoming corrupt locally or on the remote site
if done thru FP, especially when you run the compact and repair option,
which should do any time you delete data.

--

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

"novus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a large website maintained on local PC and published to my ISP. I
> have recently upgraded to FP2003.
>
> I wish to create an Access database from scratch (which will need frequent
> updating). The database is only required for the website. I am finding the
> online help pages unhelpful - maybe because I can't find the right pages..
>
> Can anyone help with the following (or point me to the appropriate help
> file):
> Where is the best place to create the database?
> Can I manipulate the database after it has been attached to FP (eg can I
add
> fields, tables etc.)?
>
> novus
>
>
>

Thank you Thomas.
The database will not allow user input. Let me see if I have this right.
I create a database somewhere on my hard disc - say datbase1
I then import into FP where it becomes database2
When I wish to edit it I export it to the desktop as database3, and then
edit it. If I have deleted data, I need to run a a compact and repair. Then
I import it back to FP as database2.

Is this correct?

I was hoping to use the database to generate numbers of short paragraphs
that are currently served as include pages or scheduled include pages. These
are added and delated a number of times a day. I may be better sticking with
my manual method for much of this data (it does allow me to embed
hyperlinks, graphics and formatting in the paragraphs. I will experiment.
Thank you for your help.

novus

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Yes, just create your database in access, then import into FP, FP will
> prompt you create connection and then to place the database in the fpdb
> folder, let it!
>
> The use the FP database component to connect to the database using the
> connection info you provided when you imported the database to display the
> content of the database in your pages.
>
> If the database is going to allow users of your site to add content, then
> you will need to create admin page to manage the database directly on the
> live site, otherwise unless you want to shut your site down, then download
> the database and make change, then upload again so that you do not over
> write any new content.
>
> If the database will just be used to supply data to the site, then export
> the database from your local FP web to your desktop, make your changes,
> re-import and then publish.
>
> Avoid edit your database directly from within FP by double-click it, etc.
as
> this can result is the file becoming corrupt locally or on the remote site
> if done thru FP, especially when you run the compact and repair option,
> which should do any time you delete data.
>
> --
>
> ==============================================
> 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
>
> "novus" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I have a large website maintained on local PC and published to my ISP. I
> > have recently upgraded to FP2003.
> >
> > I wish to create an Access database from scratch (which will need
frequent
> > updating). The database is only required for the website. I am finding
the
> > online help pages unhelpful - maybe because I can't find the right
pages..
> >
> > Can anyone help with the following (or point me to the appropriate help
> > file):
> > Where is the best place to create the database?
> > Can I manipulate the database after it has been attached to FP (eg can I
> add
> > fields, tables etc.)?
> >
> > novus
> >
> >
> >
>
>

You can keep the database using the same name at all time, there is no need
to keep changing the name. When you import,the name will not change.

--

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

"novus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thank you Thomas.
> The database will not allow user input. Let me see if I have this right.
> I create a database somewhere on my hard disc - say datbase1
> I then import into FP where it becomes database2
> When I wish to edit it I export it to the desktop as database3, and then
> edit it. If I have deleted data, I need to run a a compact and repair.
Then
> I import it back to FP as database2.
>
> Is this correct?
>
> I was hoping to use the database to generate numbers of short paragraphs
> that are currently served as include pages or scheduled include pages.
These
> are added and delated a number of times a day. I may be better sticking
with
> my manual method for much of this data (it does allow me to embed
> hyperlinks, graphics and formatting in the paragraphs. I will experiment.
> Thank you for your help.
>
> novus
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Yes, just create your database in access, then import into FP, FP will
> > prompt you create connection and then to place the database in the fpdb
> > folder, let it!
> >
> > The use the FP database component to connect to the database using the
> > connection info you provided when you imported the database to display
the
> > content of the database in your pages.
> >
> > If the database is going to allow users of your site to add content,
then
> > you will need to create admin page to manage the database directly on
the
> > live site, otherwise unless you want to shut your site down, then
download
> > the database and make change, then upload again so that you do not over
> > write any new content.
> >
> > If the database will just be used to supply data to the site, then
export
> > the database from your local FP web to your desktop, make your changes,
> > re-import and then publish.
> >
> > Avoid edit your database directly from within FP by double-click it,
etc.
> as
> > this can result is the file becoming corrupt locally or on the remote
site
> > if done thru FP, especially when you run the compact and repair option,
> > which should do any time you delete data.
> >
> > --
> >
> > ==============================================
> > 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
> >
> > "novus" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I have a large website maintained on local PC and published to my ISP.
I
> > > have recently upgraded to FP2003.
> > >
> > > I wish to create an Access database from scratch (which will need
> frequent
> > > updating). The database is only required for the website. I am finding
> the
> > > online help pages unhelpful - maybe because I can't find the right
> pages..
> > >
> > > Can anyone help with the following (or point me to the appropriate
help
> > > file):
> > > Where is the best place to create the database?
> > > Can I manipulate the database after it has been attached to FP (eg can
I
> > add
> > > fields, tables etc.)?
> > >
> > > novus
> > >
> > >
> > >
> >
> >
>
>