Database Update Site

  • Thread starter Thread starter Anonymous Chief
  • Start date Start date
A

Anonymous Chief

Hi,

I have a simple database with the following fields

-date
-number (6 characters)
-number (8 characters)
-text (50 characters)

I know that frontpage has a template that creates something like this. I
noticed that I cannot control the number of characters in the numerical
fields. Please help me. How can I do this?

Anonymous Chief
 
Edit the database in Access.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
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.
==============================================
 
Yes, you can.

However you will be much better off exporting the database to your desktop, then editing, etc. in
Access, close Access and then re-import the database back into your web.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
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.
==============================================
 
I'm assuming that I would have started this with the database wizard in FP.
How do I export the file and then later import the file back to the web?

Anonymous Chief
 
You can use FP database components or you can learn to hand code your ASP and manually create your
database, etc.

To export, use File Menu | Export

To import, use File Menu | Import or drag-n-drop the database into the fpdb folder.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
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.
==============================================
 
Select the File in Folder List or Folder View and right click for File Export
(browse to your desktop for the save location)

Select the Folder (usually fpdb) in Folder List or Folder View and from the menu select File Import - Add files
(browse to your desktop for the DB file)

--




| I'm assuming that I would have started this with the database wizard in FP.
| How do I export the file and then later import the file back to the web?
|
| Anonymous Chief
|
| | > Yes, you can.
| >
| > However you will be much better off exporting the database to your
| > desktop, then editing, etc. in Access, close Access and then re-import the
| > database back into your web.
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > 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.
| > ==============================================
| >
| > | >> So I just open the database with Access while it is still in my frontpage
| >> web.
| >>
| >> | >>> Edit the database in Access.
| >>>
| >>> --
| >>> ==============================================
| >>> Thomas A. Rowe (Microsoft MVP - FrontPage)
| >>> ==============================================
| >>> 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.
| >>> ==============================================
| >>>
| >>> | >>>> Hi,
| >>>>
| >>>> I have a simple database with the following fields
| >>>>
| >>>> -date
| >>>> -number (6 characters)
| >>>> -number (8 characters)
| >>>> -text (50 characters)
| >>>>
| >>>> I know that frontpage has a template that creates something like this.
| >>>> I noticed that I cannot control the number of characters in the
| >>>> numerical fields. Please help me. How can I do this?
| >>>>
| >>>> Anonymous Chief
| >>>>
| >>>
| >>>
| >>
| >>
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top