Adding records to a Access database through frontpage

[chinkoh]

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.aspx?scid=kb;EN-US;219158
However, that did not help.

Are there specific steps that must be taken?

Any help is greatly appreciated.

Thanks

 

[Mark Fitzpatrick]

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

 

[Trevor L.]

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.

 

[Paul C]

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]

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!

 

[Paul C]

Hi
Have you tried creating the form first then using the form properties to
create the database from there?
Paul M

 

[chinkoh]

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

 

[chinkoh]

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

 

[Thomas A. Rowe]

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]

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]

The FP extensions come into play by creating and setting the permissions on the fpdb folder and the
creation of the global.asa file.

IIS (Internet Information Services) = Web Server

Do not manually modify the permissions, let FP manage them.

Where is you web currently located on your HD? Under Windows XP you should really leave the default
web and publish your web to that location, which would be http://localhost or http://machinename or
http://127.0.0.1


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

 

[chinkoh]

Hi Thomas

Thanks!

I tried something else that worked. I have no idea how this will impact
the web when it is finally published on the web.

What I tried was to use
http://127.0.0.1/CDVL/test.asp
which worked to view the asp page and submit data instead of
http://machinename.com/CDVL/test.asp
which did not work.

Is there something different here that is important?

Also under properties in IIS, there is a tab that says server
extensions. This I assume is the frontpage server extensions.

I am going to try and different settings to see what is actually
happening here.

Thanks
Chin

 

[chinkoh]

Hi Thomas

Thanks!

I tried something else that worked. I have no idea how this will impact
the web when it is finally published on the web.

What I tried was to use
http://127.0.0.1/CDVL/test.asp
which worked to view the asp page and submit data instead of
http://machinename.com/CDVL/test.asp
which did not work.

Is there something different here that is important?

Also under properties in IIS, there is a tab that says server
extensions. This I assume is the frontpage server extensions.

I am going to try and different settings to see what is actually
happening here.

Thanks
Chin

 

[Thomas A. Rowe]

You can't use anything with ".com" on your local machine.

Try http://machinename (this is the name assigned to your PC)
or
http://localhost

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

 

[chinkoh]

Oops, typo. I meant

http://machinename/CDVL/test.asp
This didn't work, neither did this
http://localhost/CDVL/test.asp

What is so unique about

http://127.0.0.1 compared to http://localhost or http://machinename ?

Thanks
Chin


I tried

 

[Thomas A. Rowe]

Both http://localhost or http://machinename should take you to http://127.0.0.1

However your firewall could be blocking them. Since you have access via http://127.0.0.1 just
continue to always access your web from FP or your browser using it.

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