What happens is that the new fields are added to the database in the fpdb
directory in your local web. When you publish, that version is written over
the database on your web. All information gone ... - at least w. FP 2002.
Solution: Copy the current database from the web to your fpdb directory. Do
the update, publish, and check when asked that noone has added info to the
web while you were updating.
"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try it on your live/remote site... Export your current live/remote
> database to your desktop as a backup.
>
>
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
>
> "shikha" <(E-Mail Removed)> wrote in message
> news:CC273E52-7D04-497E-A64D-(E-Mail Removed)...
>> Hi,
>>
>> I have a form which users will fill out, and is working great. Now, I
>> would
>> like to add three new fields to the form...I looked at the database
>> option...it does have Updating database option, which basically tells it
>> will
>> create a new column in the database for any new fields added to the
>> current
>> form.
>>
>> I just wanna make sure...If I go with that option, my records in database
>> will still be there, and I will not be losing any data...and also when it
>> adds new column in the database, for any existing records, will this
>> column
>> be empty?
>>
>> Any help will be greatly appreciated!
>>
>> Thanks,
>>
>> Shikha
>
>
Similar Threads
