Re: Database change

From: Kathleen Anderson [MVP - FP] (spiderwebwoman_at_mvps.org)
Date: 05/02/04 

Date: Sun, 2 May 2004 08:55:29 -0400

OK - here's two other things to try: verify your database connection: go to
Tools | Web Settings | Database click once on the connection and click the
Verify button, and click OK.

Try creating a new query page - is the new field available? 

-- 
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
anonymous@discussions.microsoft.com wrote:
> I did all that, but same results.  New field not available.
>> -----Original Message-----
>> I would recommend exporting the database from your web down to your
>> hard drive, delete the database and the global.asa from your web and
>> then reimport the database (give it the same DSN as you did the
>> first time) and let FP recreate the global.asa. That should fix it.
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> anonymous@discussions.microsoft.com wrote:
>>> I updated database on hard drive in FrontPage (in folder
>>> fpdb)so no need to reimport.
>>>
>>>> -----Original Message-----
>>>> Did you update the database on your hard drive and reimport it into
>>>> your web or did you update the database in your web?
>>>>
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> Robert <anonymous@discussions.microsoft.com> wrote:
>>>>> I want to add a field to my front page database. Adding
>>>>> the new column to database is no problem.  When I go to
>>>>> results form to add new field via "Insert Database Column
>>>>> Value", the new field I added in database does not appear
>>>>> in drop down list?  As we all know, we can't use wizaed to
>>>>> do these updates.  How do I modify my database after
>>>>> wizard generates results and editor?
>>>>
>>>> .
>>
>> .