I am using WinXP pro, IIS5.1, FP2003.

I have created an imported a database into the web. I have also
successfully accessed and displayed the records in the database using a
combination of DRW and direct manipulation of the asp code.

The problem is trying to add records to the database.

I have tried directly creating a form and making sure that the form
fields and database columns match. Connections were also verified. I
access the form through the browser and added a record. The operation
completed successfully, however, no data was actually recorded.

I have also used the DIW to no avail. Same problem, successful
completion but no data actually written.

I have seen the KB
http://support.microsoft.com/default...b;EN-US;219158
However, that did not help.

Are there specific steps that must be taken?

Any help is greatly appreciated.

Thanks

The location of the database in your site is key. By default, FP should
create an fpdb directory to store the database in. This directory is
important because it has the proper user permissions set upon it. You need
to allow the IUSR account (that's the user account ASP and IIS will
authenticate with) to have read/write/delete access to the database. If
these permissions aren't present then the database won't be able to
insert/update/delete items, only select.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"chinkoh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using WinXP pro, IIS5.1, FP2003.
>
> I have created an imported a database into the web. I have also
> successfully accessed and displayed the records in the database using a
> combination of DRW and direct manipulation of the asp code.
>
> The problem is trying to add records to the database.
>
> I have tried directly creating a form and making sure that the form
> fields and database columns match. Connections were also verified. I
> access the form through the browser and added a record. The operation
> completed successfully, however, no data was actually recorded.
>
> I have also used the DIW to no avail. Same problem, successful
> completion but no data actually written.
>
> I have seen the KB
> http://support.microsoft.com/default...b;EN-US;219158
> However, that did not help.
>
> Are there specific steps that must be taken?
>
> Any help is greatly appreciated.
>
> Thanks
>

Mark Fitzpatrick wrote:
> The location of the database in your site is key. By default, FP
> should create an fpdb directory to store the database in. This
> directory is important because it has the proper user permissions set
> upon it. You need to allow the IUSR account (that's the user account
> ASP and IIS will authenticate with) to have read/write/delete access
> to the database. If these permissions aren't present then the
> database won't be able to insert/update/delete items, only select.
>
> Hope this helps,
> Mark Fitzpatrick
> Microsoft MVP - FrontPage

Mark, perhaps you can also help me.

I have set up a database on the site below, but I can only read it, not
udpate it.

Originally I put the database on fpdb/ and set the links to this folder, but
when this didn't work I also tried putting it on the root folder.

Some questions
Do you have a site at mvps.org?
Does it have a database?
Can you update it?
If so, can you tell me what I need to do?

I thought there may be a need to have the admin to set permissions, but I
also didn't know which folder the permissions needed to be set on.
I have tried sending an email to the admin (Felix) to see if they can help,
but with no reply so far.
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/

Hi
Check that the fields in the database are set to the correct length for the
input form ie you are not trying to put 100 chars into a database field that
is set for 80 chars or the wrong format ie numbers instead of letters.This
can also cause the entry to be ignored.
And check that you are allowing duplicates in database fields so if
someones called John adds a record into a first name field and then someone
else tries to add a record called John this will also cause nothing to be
added
You will need to check these type of thing
Paul M

"chinkoh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using WinXP pro, IIS5.1, FP2003.
>
> I have created an imported a database into the web. I have also
> successfully accessed and displayed the records in the database using a
> combination of DRW and direct manipulation of the asp code.
>
> The problem is trying to add records to the database.
>
> I have tried directly creating a form and making sure that the form
> fields and database columns match. Connections were also verified. I
> access the form through the browser and added a record. The operation
> completed successfully, however, no data was actually recorded.
>
> I have also used the DIW to no avail. Same problem, successful
> completion but no data actually written.
>
> I have seen the KB
> http://support.microsoft.com/default...b;EN-US;219158
> However, that did not help.
>
> Are there specific steps that must be taken?
>
> Any help is greatly appreciated.
>
> Thanks
>

Hi Mark
Thanks for taking your time to look at this. I have ensured that the
steps you pointed out were taken care of, but got the same problem.

Perhaps you can go through some of the details of how i created the
form.

1. Create a new database (test.db) with one table (Results), two
fields, an autonumber field for the primary key, and another field
which I have called value1. The field value1 was set to text with
default values.
2. Imported the database into frontpage, which was placed into \fpdb.
The necessary connections were verified.
3. Create a new page and named it test.asp.
4. Inserted a form using Insert | Form | Form.
5 Inserted a text box using Insert | Form | Textbox.
6. In the textbox properties, changed the name to value1 and the rest
of the selections set to default.
7. In form properties, selected 'send to database'
8. In form properties, saved fields, ensured that the formfield and
database columns matched, i.e. both are value1.
9. In IIS, I selected the \fpdb directory and checked, script source
access, read, write,directory browsing, log visits, and index this
resource.
10. Open test.asp in a web browser and key in information. Here I have
entered one1 into the lone textbox. hit submit and get a confirmation
page.
11. Open test.db and nothing has been added.

Any suggestions?

Thanks!



Mark Fitzpatrick wrote:
> The location of the database in your site is key. By default, FP should
> create an fpdb directory to store the database in. This directory is
> important because it has the proper user permissions set upon it. You need
> to allow the IUSR account (that's the user account ASP and IIS will
> authenticate with) to have read/write/delete access to the database. If
> these permissions aren't present then the database won't be able to
> insert/update/delete items, only select.
>
> Hope this helps,
> Mark Fitzpatrick
> Microsoft MVP - FrontPage
>
> "chinkoh" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I am using WinXP pro, IIS5.1, FP2003.
> >
> > I have created an imported a database into the web. I have also
> > successfully accessed and displayed the records in the database using a
> > combination of DRW and direct manipulation of the asp code.
> >
> > The problem is trying to add records to the database.
> >
> > I have tried directly creating a form and making sure that the form
> > fields and database columns match. Connections were also verified. I
> > access the form through the browser and added a record. The operation
> > completed successfully, however, no data was actually recorded.
> >
> > I have also used the DIW to no avail. Same problem, successful
> > completion but no data actually written.
> >
> > I have seen the KB
> > http://support.microsoft.com/default...b;EN-US;219158
> > However, that did not help.
> >
> > Are there specific steps that must be taken?
> >
> > Any help is greatly appreciated.
> >
> > Thanks
> >

Hi
Have you tried creating the form first then using the form properties to
create the database from there?
Paul M
"chinkoh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Mark
> Thanks for taking your time to look at this. I have ensured that the
> steps you pointed out were taken care of, but got the same problem.
>
> Perhaps you can go through some of the details of how i created the
> form.
>
> 1. Create a new database (test.db) with one table (Results), two
> fields, an autonumber field for the primary key, and another field
> which I have called value1. The field value1 was set to text with
> default values.
> 2. Imported the database into frontpage, which was placed into \fpdb.
> The necessary connections were verified.
> 3. Create a new page and named it test.asp.
> 4. Inserted a form using Insert | Form | Form.
> 5 Inserted a text box using Insert | Form | Textbox.
> 6. In the textbox properties, changed the name to value1 and the rest
> of the selections set to default.
> 7. In form properties, selected 'send to database'
> 8. In form properties, saved fields, ensured that the formfield and
> database columns matched, i.e. both are value1.
> 9. In IIS, I selected the \fpdb directory and checked, script source
> access, read, write,directory browsing, log visits, and index this
> resource.
> 10. Open test.asp in a web browser and key in information. Here I have
> entered one1 into the lone textbox. hit submit and get a confirmation
> page.
> 11. Open test.db and nothing has been added.
>
> Any suggestions?
>
> Thanks!
>
>
>
> Mark Fitzpatrick wrote:
>> The location of the database in your site is key. By default, FP should
>> create an fpdb directory to store the database in. This directory is
>> important because it has the proper user permissions set upon it. You
>> need
>> to allow the IUSR account (that's the user account ASP and IIS will
>> authenticate with) to have read/write/delete access to the database. If
>> these permissions aren't present then the database won't be able to
>> insert/update/delete items, only select.
>>
>> Hope this helps,
>> Mark Fitzpatrick
>> Microsoft MVP - FrontPage
>>
>> "chinkoh" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >I am using WinXP pro, IIS5.1, FP2003.
>> >
>> > I have created an imported a database into the web. I have also
>> > successfully accessed and displayed the records in the database using a
>> > combination of DRW and direct manipulation of the asp code.
>> >
>> > The problem is trying to add records to the database.
>> >
>> > I have tried directly creating a form and making sure that the form
>> > fields and database columns match. Connections were also verified. I
>> > access the form through the browser and added a record. The operation
>> > completed successfully, however, no data was actually recorded.
>> >
>> > I have also used the DIW to no avail. Same problem, successful
>> > completion but no data actually written.
>> >
>> > I have seen the KB
>> > http://support.microsoft.com/default...b;EN-US;219158
>> > However, that did not help.
>> >
>> > Are there specific steps that must be taken?
>> >
>> > Any help is greatly appreciated.
>> >
>> > Thanks
>> >
>

Hi Paul

Yes, I have tried it that way too. From what I understand, this will
prevent any errors related to form field and database columns not being
exactly the same.

I also tried using the databse interface wizard to setup the forms.

Thanks
Chin


Paul C wrote:
> Hi
> Have you tried creating the form first then using the form properties to
> create the database from there?
> Paul M
> "chinkoh" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi Mark
> > Thanks for taking your time to look at this. I have ensured that the
> > steps you pointed out were taken care of, but got the same problem.
> >
> > Perhaps you can go through some of the details of how i created the
> > form.
> >
> > 1. Create a new database (test.db) with one table (Results), two
> > fields, an autonumber field for the primary key, and another field
> > which I have called value1. The field value1 was set to text with
> > default values.
> > 2. Imported the database into frontpage, which was placed into \fpdb.
> > The necessary connections were verified.
> > 3. Create a new page and named it test.asp.
> > 4. Inserted a form using Insert | Form | Form.
> > 5 Inserted a text box using Insert | Form | Textbox.
> > 6. In the textbox properties, changed the name to value1 and the rest
> > of the selections set to default.
> > 7. In form properties, selected 'send to database'
> > 8. In form properties, saved fields, ensured that the formfield and
> > database columns matched, i.e. both are value1.
> > 9. In IIS, I selected the \fpdb directory and checked, script source
> > access, read, write,directory browsing, log visits, and index this
> > resource.
> > 10. Open test.asp in a web browser and key in information. Here I have
> > entered one1 into the lone textbox. hit submit and get a confirmation
> > page.
> > 11. Open test.db and nothing has been added.
> >
> > Any suggestions?
> >
> > Thanks!
> >
> >
> >
> > Mark Fitzpatrick wrote:
> >> The location of the database in your site is key. By default, FP should
> >> create an fpdb directory to store the database in. This directory is
> >> important because it has the proper user permissions set upon it. You
> >> need
> >> to allow the IUSR account (that's the user account ASP and IIS will
> >> authenticate with) to have read/write/delete access to the database. If
> >> these permissions aren't present then the database won't be able to
> >> insert/update/delete items, only select.
> >>
> >> Hope this helps,
> >> Mark Fitzpatrick
> >> Microsoft MVP - FrontPage
> >>
> >> "chinkoh" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> >I am using WinXP pro, IIS5.1, FP2003.
> >> >
> >> > I have created an imported a database into the web. I have also
> >> > successfully accessed and displayed the records in the database using a
> >> > combination of DRW and direct manipulation of the asp code.
> >> >
> >> > The problem is trying to add records to the database.
> >> >
> >> > I have tried directly creating a form and making sure that the form
> >> > fields and database columns match. Connections were also verified. I
> >> > access the form through the browser and added a record. The operation
> >> > completed successfully, however, no data was actually recorded.
> >> >
> >> > I have also used the DIW to no avail. Same problem, successful
> >> > completion but no data actually written.
> >> >
> >> > I have seen the KB
> >> > http://support.microsoft.com/default...b;EN-US;219158
> >> > However, that did not help.
> >> >
> >> > Are there specific steps that must be taken?
> >> >
> >> > Any help is greatly appreciated.
> >> >
> >> > Thanks
> >> >
> >

Something else to add.

I tried sending the form data to a csv file and a text file. Upon
entering the data into the text box and hitting submit, no defult
confirmation page was displayed, and neither of the files contained any
results.

Does this mean that I have a configuration problem? I checked the
permissions, and I have gone to the extent of making all folders and
its contents , read, write, and executable.

I have further did a uninstall and a reinstall of IIS.

Any ideas?
Thanks
Chin



chinkoh wrote:
> Hi Paul
>
> Yes, I have tried it that way too. From what I understand, this will
> prevent any errors related to form field and database columns not being
> exactly the same.
>
> I also tried using the databse interface wizard to setup the forms.
>
> Thanks
> Chin
>
>
> Paul C wrote:
> > Hi
> > Have you tried creating the form first then using the form properties to
> > create the database from there?
> > Paul M
> > "chinkoh" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hi Mark
> > > Thanks for taking your time to look at this. I have ensured that the
> > > steps you pointed out were taken care of, but got the same problem.
> > >
> > > Perhaps you can go through some of the details of how i created the
> > > form.
> > >
> > > 1. Create a new database (test.db) with one table (Results), two
> > > fields, an autonumber field for the primary key, and another field
> > > which I have called value1. The field value1 was set to text with
> > > default values.
> > > 2. Imported the database into frontpage, which was placed into \fpdb.
> > > The necessary connections were verified.
> > > 3. Create a new page and named it test.asp.
> > > 4. Inserted a form using Insert | Form | Form.
> > > 5 Inserted a text box using Insert | Form | Textbox.
> > > 6. In the textbox properties, changed the name to value1 and the rest
> > > of the selections set to default.
> > > 7. In form properties, selected 'send to database'
> > > 8. In form properties, saved fields, ensured that the formfield and
> > > database columns matched, i.e. both are value1.
> > > 9. In IIS, I selected the \fpdb directory and checked, script source
> > > access, read, write,directory browsing, log visits, and index this
> > > resource.
> > > 10. Open test.asp in a web browser and key in information. Here I have
> > > entered one1 into the lone textbox. hit submit and get a confirmation
> > > page.
> > > 11. Open test.db and nothing has been added.
> > >
> > > Any suggestions?
> > >
> > > Thanks!
> > >
> > >
> > >
> > > Mark Fitzpatrick wrote:
> > >> The location of the database in your site is key. By default, FP should
> > >> create an fpdb directory to store the database in. This directory is
> > >> important because it has the proper user permissions set upon it. You
> > >> need
> > >> to allow the IUSR account (that's the user account ASP and IIS will
> > >> authenticate with) to have read/write/delete access to the database. If
> > >> these permissions aren't present then the database won't be able to
> > >> insert/update/delete items, only select.
> > >>
> > >> Hope this helps,
> > >> Mark Fitzpatrick
> > >> Microsoft MVP - FrontPage
> > >>
> > >> "chinkoh" <(E-Mail Removed)> wrote in message
> > >> news:(E-Mail Removed)...
> > >> >I am using WinXP pro, IIS5.1, FP2003.
> > >> >
> > >> > I have created an imported a database into the web. I have also
> > >> > successfully accessed and displayed the records in the database using a
> > >> > combination of DRW and direct manipulation of the asp code.
> > >> >
> > >> > The problem is trying to add records to the database.
> > >> >
> > >> > I have tried directly creating a form and making sure that the form
> > >> > fields and database columns match. Connections were also verified. I
> > >> > access the form through the browser and added a record. The operation
> > >> > completed successfully, however, no data was actually recorded.
> > >> >
> > >> > I have also used the DIW to no avail. Same problem, successful
> > >> > completion but no data actually written.
> > >> >
> > >> > I have seen the KB
> > >> > http://support.microsoft.com/default...b;EN-US;219158
> > >> > However, that did not help.
> > >> >
> > >> > Are there specific steps that must be taken?
> > >> >
> > >> > Any help is greatly appreciated.
> > >> >
> > >> > Thanks
> > >> >
> > >

Have you actually installed and configured the FP extensions (from the Windows CD) for the specific
web site from within the IIS MMC?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


"chinkoh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Something else to add.
>
> I tried sending the form data to a csv file and a text file. Upon
> entering the data into the text box and hitting submit, no defult
> confirmation page was displayed, and neither of the files contained any
> results.
>
> Does this mean that I have a configuration problem? I checked the
> permissions, and I have gone to the extent of making all folders and
> its contents , read, write, and executable.
>
> I have further did a uninstall and a reinstall of IIS.
>
> Any ideas?
> Thanks
> Chin
>
>
>
> chinkoh wrote:
>> Hi Paul
>>
>> Yes, I have tried it that way too. From what I understand, this will
>> prevent any errors related to form field and database columns not being
>> exactly the same.
>>
>> I also tried using the databse interface wizard to setup the forms.
>>
>> Thanks
>> Chin
>>
>>
>> Paul C wrote:
>> > Hi
>> > Have you tried creating the form first then using the form properties to
>> > create the database from there?
>> > Paul M
>> > "chinkoh" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> > > Hi Mark
>> > > Thanks for taking your time to look at this. I have ensured that the
>> > > steps you pointed out were taken care of, but got the same problem.
>> > >
>> > > Perhaps you can go through some of the details of how i created the
>> > > form.
>> > >
>> > > 1. Create a new database (test.db) with one table (Results), two
>> > > fields, an autonumber field for the primary key, and another field
>> > > which I have called value1. The field value1 was set to text with
>> > > default values.
>> > > 2. Imported the database into frontpage, which was placed into \fpdb.
>> > > The necessary connections were verified.
>> > > 3. Create a new page and named it test.asp.
>> > > 4. Inserted a form using Insert | Form | Form.
>> > > 5 Inserted a text box using Insert | Form | Textbox.
>> > > 6. In the textbox properties, changed the name to value1 and the rest
>> > > of the selections set to default.
>> > > 7. In form properties, selected 'send to database'
>> > > 8. In form properties, saved fields, ensured that the formfield and
>> > > database columns matched, i.e. both are value1.
>> > > 9. In IIS, I selected the \fpdb directory and checked, script source
>> > > access, read, write,directory browsing, log visits, and index this
>> > > resource.
>> > > 10. Open test.asp in a web browser and key in information. Here I have
>> > > entered one1 into the lone textbox. hit submit and get a confirmation
>> > > page.
>> > > 11. Open test.db and nothing has been added.
>> > >
>> > > Any suggestions?
>> > >
>> > > Thanks!
>> > >
>> > >
>> > >
>> > > Mark Fitzpatrick wrote:
>> > >> The location of the database in your site is key. By default, FP should
>> > >> create an fpdb directory to store the database in. This directory is
>> > >> important because it has the proper user permissions set upon it. You
>> > >> need
>> > >> to allow the IUSR account (that's the user account ASP and IIS will
>> > >> authenticate with) to have read/write/delete access to the database. If
>> > >> these permissions aren't present then the database won't be able to
>> > >> insert/update/delete items, only select.
>> > >>
>> > >> Hope this helps,
>> > >> Mark Fitzpatrick
>> > >> Microsoft MVP - FrontPage
>> > >>
>> > >> "chinkoh" <(E-Mail Removed)> wrote in message
>> > >> news:(E-Mail Removed)...
>> > >> >I am using WinXP pro, IIS5.1, FP2003.
>> > >> >
>> > >> > I have created an imported a database into the web. I have also
>> > >> > successfully accessed and displayed the records in the database using a
>> > >> > combination of DRW and direct manipulation of the asp code.
>> > >> >
>> > >> > The problem is trying to add records to the database.
>> > >> >
>> > >> > I have tried directly creating a form and making sure that the form
>> > >> > fields and database columns match. Connections were also verified. I
>> > >> > access the form through the browser and added a record. The operation
>> > >> > completed successfully, however, no data was actually recorded.
>> > >> >
>> > >> > I have also used the DIW to no avail. Same problem, successful
>> > >> > completion but no data actually written.
>> > >> >
>> > >> > I have seen the KB
>> > >> > http://support.microsoft.com/default...b;EN-US;219158
>> > >> > However, that did not help.
>> > >> >
>> > >> > Are there specific steps that must be taken?
>> > >> >
>> > >> > Any help is greatly appreciated.
>> > >> >
>> > >> > Thanks
>> > >> >
>> > >
>

Hi Thomas

Since I am very new to this (started in the last month), I am not sure
what is the difference between FP server extensions and Internet
Information services.

This is what I did. I went to add/remove programs, Add/Remove Windows
Components.
In the Windows Components Wizard, select Internet Information Services.

Then I went into IIS and created a virtual directory that pointed to
the folder that contained the web. I changed the permissions to include
read and write access and also to allow scripts to be run.

I am not sure where server extensions actually come into play here. Am
I missing something here?

Thanks
Chin

Thomas A. Rowe wrote:
> Have you actually installed and configured the FP extensions (from the Windows CD) for the specific
> web site from within the IIS MMC?
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
> ==============================================
> Agents Real Estate Listing Network
> http://www.NReal.com
> ==============================================
>
>
> "chinkoh" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Something else to add.
> >
> > I tried sending the form data to a csv file and a text file. Upon
> > entering the data into the text box and hitting submit, no defult
> > confirmation page was displayed, and neither of the files contained any
> > results.
> >
> > Does this mean that I have a configuration problem? I checked the
> > permissions, and I have gone to the extent of making all folders and
> > its contents , read, write, and executable.
> >
> > I have further did a uninstall and a reinstall of IIS.
> >
> > Any ideas?
> > Thanks
> > Chin
> >
> >
> >
> > chinkoh wrote:
> >> Hi Paul
> >>
> >> Yes, I have tried it that way too. From what I understand, this will
> >> prevent any errors related to form field and database columns not being
> >> exactly the same.
> >>
> >> I also tried using the databse interface wizard to setup the forms.
> >>
> >> Thanks
> >> Chin
> >>
> >>
> >> Paul C wrote:
> >> > Hi
> >> > Have you tried creating the form first then using the form properties to
> >> > create the database from there?
> >> > Paul M
> >> > "chinkoh" <(E-Mail Removed)> wrote in message
> >> > news:(E-Mail Removed)...
> >> > > Hi Mark
> >> > > Thanks for taking your time to look at this. I have ensured that the
> >> > > steps you pointed out were taken care of, but got the same problem.
> >> > >
> >> > > Perhaps you can go through some of the details of how i created the
> >> > > form.
> >> > >
> >> > > 1. Create a new database (test.db) with one table (Results), two
> >> > > fields, an autonumber field for the primary key, and another field
> >> > > which I have called value1. The field value1 was set to text with
> >> > > default values.
> >> > > 2. Imported the database into frontpage, which was placed into \fpdb.
> >> > > The necessary connections were verified.
> >> > > 3. Create a new page and named it test.asp.
> >> > > 4. Inserted a form using Insert | Form | Form.
> >> > > 5 Inserted a text box using Insert | Form | Textbox.
> >> > > 6. In the textbox properties, changed the name to value1 and the rest
> >> > > of the selections set to default.
> >> > > 7. In form properties, selected 'send to database'
> >> > > 8. In form properties, saved fields, ensured that the formfield and
> >> > > database columns matched, i.e. both are value1.
> >> > > 9. In IIS, I selected the \fpdb directory and checked, script source
> >> > > access, read, write,directory browsing, log visits, and index this
> >> > > resource.
> >> > > 10. Open test.asp in a web browser and key in information. Here I have
> >> > > entered one1 into the lone textbox. hit submit and get a confirmation
> >> > > page.
> >> > > 11. Open test.db and nothing has been added.
> >> > >
> >> > > Any suggestions?
> >> > >
> >> > > Thanks!
> >> > >
> >> > >
> >> > >
> >> > > Mark Fitzpatrick wrote:
> >> > >> The location of the database in your site is key. By default, FP should
> >> > >> create an fpdb directory to store the database in. This directory is
> >> > >> important because it has the proper user permissions set upon it. You
> >> > >> need
> >> > >> to allow the IUSR account (that's the user account ASP and IIS will
> >> > >> authenticate with) to have read/write/delete access to the database. If
> >> > >> these permissions aren't present then the database won't be able to
> >> > >> insert/update/delete items, only select.
> >> > >>
> >> > >> Hope this helps,
> >> > >> Mark Fitzpatrick
> >> > >> Microsoft MVP - FrontPage
> >> > >>
> >> > >> "chinkoh" <(E-Mail Removed)> wrote in message
> >> > >> news:(E-Mail Removed)...
> >> > >> >I am using WinXP pro, IIS5.1, FP2003.
> >> > >> >
> >> > >> > I have created an imported a database into the web. I have also
> >> > >> > successfully accessed and displayed the records in the database using a
> >> > >> > combination of DRW and direct manipulation of the asp code.
> >> > >> >
> >> > >> > The problem is trying to add records to the database.
> >> > >> >
> >> > >> > I have tried directly creating a form and making sure that the form
> >> > >> > fields and database columns match. Connections were also verified. I
> >> > >> > access the form through the browser and added a record. The operation
> >> > >> > completed successfully, however, no data was actually recorded.
> >> > >> >
> >> > >> > I have also used the DIW to no avail. Same problem, successful
> >> > >> > completion but no data actually written.
> >> > >> >
> >> > >> > I have seen the KB
> >> > >> > http://support.microsoft.com/default...b;EN-US;219158
> >> > >> > However, that did not help.
> >> > >> >
> >> > >> > Are there specific steps that must be taken?
> >> > >> >
> >> > >> > Any help is greatly appreciated.
> >> > >> >
> >> > >> > Thanks
> >> > >> >
> >> > >
> >