Problem capturing web data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Applies to Access 2000, FrontPage 2000, IIS 5.1 on XP Pro



I have created two tables in an Access database as follows:



Table 1 - Registration:

userName: Text (Primary Key)

Password: Text



Table 2 - Personal

ID: AutoNumber (Primary Key)

firstName: Text

lastName: Text

address1: Text

address2: Text

towncity: Text

county: Text

postcode: Text

telephone: Text

mobile: Text

email: Text

dateofbirth: Text



I have created a Relationship from the userName Field in the Registration
Table to the ID Field on the Personal Table (the two Primary Key Fields)



I then created two asp web pages in FrontPage using Text Boxes to represent
each of the above Fields and made sure the length was correct and each was
linked up to the correct Table Field in the database.



The problem occurs when I open Registration.asp and enter a userName and
Password and click the submit button, it takes me to the Personal.asp web
page and I then complete all the fields for that table and click the Submit
button again, but when I open the Access database to check that the data was
captured, the following occurs:



Data is captured correctly into the Registration Table and if I click the
little Plus Sign to the left of the data, it opens up the fields for the
Personal Table but no data has been captured, and even if I open the
Personal Table separately in the database, no data is present and I cannot
understand why?



Can anybody see something obvious that I may be doing wrong, I'm certainly
not an expert with Access but I thought it would be a fairly simple and
straight forward task to just link two tables and capture data through an
..asp web page correctly.



Any help or guidance would be greatly appreciated.



Kind Regards,

Wayne


.

Relevant Pages

  • Re: Runtime Error Paste Method of Worksheet class failed
    ... > Private Sub CommandButton1_Click ... > Dim rngToPaste As Range ... > 'opens access ... > ' exports data from the active worksheet to a table in an Access database ...
    (microsoft.public.excel.programming)
  • Re: Runtime Error Paste Method of Worksheet class failed
    ... >> Private Sub CommandButton1_Click ... >> Dim rngToPaste As Range ... >> 'opens access ... >> ' exports data from the active worksheet to a table in an Access database ...
    (microsoft.public.excel.programming)
  • VB, ADO,Access 2000 and Record order
    ... I have a simple VB project with a function: It opens a connection to ... access database and perform an INSERT sql query. ... the second and a series of autonumber numbers! ...
    (microsoft.public.vb.general.discussion)
  • Re: Valid password characters
    ... > Often when one registers on different web sites around the world, ... > a pretty hard limitation on what characters I am allowed to use in my ... > username and password. ...
    (microsoft.public.inetserver.asp.db)
  • RE: creating a SQL SELECT statement with javascript
    ... I have a very simple MS Access database consisting of three ... fields: username, password and stylesheet. ... To address a control on a form in Access, ...
    (microsoft.public.access.formscoding)