Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Warrington, Cheshire, England
    Thanked 0 Times in 0 Posts

    Sub Datasheet link lost (2003)

    Something that's been done to a DB during development has caused the sub datasheet link between two tables to be lost.
    The two tables are still there and have not been renamed. A field has been moved from EmployeeDetail table to Salary table and the original field deleted from EmployeeDetail.
    At the end of this part of the development, the link is still there; opening EmployeeDetail and then clicking on the plus sign shows the associated Salary info.
    Post this, there have been changes to queries, but I can't see how this can affect the datasheet/subdatasheet link. What sort of thing could I have done to cause the link to disappear?
    (I know it's simple to remake the link when I am prompted by Access - but I would like to know what I've done to make it disappear)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Sub Datasheet link lost (2003)

    I have no idea, but I'd recommend turning off subdatasheets. They can have unexpected effects and have a negative impact on performance. See the 'Tables: SubdatasheetName' section in Allen Browne's Microsoft Access Flaws - Problem properties.

Posting Permissions

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