Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Northumberland, England

    Post Unanswered: Web interface for Access

    Hi all,

    I'm trying to create a web interface for an access database that resides on one of my company's servers. Due to restrictions i can't use any other DB solution (shame as it would make it easier)

    The database consists of 3 main tables, shown in the screen grab. My question is this, how do I perform an update to all 3 tables when I don't know the aboutYouID pk from the first table as this is being created in the table at the same time as the others?

    Potentially more than one person could be updating their details at the same time so simply pulling the last record from the table and using this is impossible surely?

    How can i get around this.

    Attached Thumbnails Attached Thumbnails DB.gif  

  2. #2
    Join Date
    Jul 2005
    Mildura VIC, Australia

    User Tracking

    Hi daffy

    When you create an entry in the first table, you will need to store its value in a session variable, or pass it from page to page.

    After adding a record using ADO, you can use the movefirst method of the ADO recordset object and read the newly created value.

    Smartsave Pty Ltd has considerable experience in developing applications of this nature, and can be of further assistance.



  3. #3
    Join Date
    Jun 2003
    And for a possibly related link: : ASP FAQS : Databases, General
    How do I get the record number of a just added record, using an Access database table? by Bill Wilkinson - 11/3/2000
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts