Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Nov 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DAP New Record Problem (2003)

    I'm trying to create a data access page from a table that uses lookups for two fields that are located in other tables. The DAP will view the information correctly but it will not allow me to edit/add/delete records. I'm presuming it's because of the lookup fields because I tried to do the same thing with a table that contained just straight text/number fields and it worked fine. Is there anyway around this problem? I don't want to eliminate the lookups because it would mean manual data entry of repetitive information. Thanks.
    -Kim

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DAP New Record Problem (2003)

    There are not many people here who use Data Access Pages, so you may not get an answer soon. It might help if you could post a stripped down copy of the database containing the table.

  3. #3
    New Lounger
    Join Date
    Nov 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAP New Record Problem (2003)

    Attached is a scaled example of the database. I would like to have the form "Family" accessible to someone who does not have access so I thought a DAP would be the way to go. Any help would be great.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DAP New Record Problem (2003)

    I hope someone will be able to help. (I don't know anything about DAPs, I'm clueless here)

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAP New Record Problem (2003)

    Since you're talking about an Access form, how can that someone access it without having Access?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DAP New Record Problem (2003)

    A Data Access Page is a special web page that connects to the database.

Posting Permissions

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