Adding a databse

[novus]

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

 

[Thomas A. Rowe]

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)

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

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)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================