Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    SubDataSheet (2003)

    Hi All -
    I have a table that if I open it up from the backend it has a subdatasheet plus sign shown. If I open the same table from the front end the plus sign does not appear for the subdatasheet. The database is saved in 2000 format. If I copy the front end to a machine running accessxp or access2000 the plus sign is there when I open up the table from the same front end. Any ideas on what is going on? I also realize that users are usually not allowed to open up the tables. Thanks in advance.
    John

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SubDataSheet (2003)

    In general there is a significant performance hit when you have subdatasheets active, and it is even more noticeable when the tables are linked. I do not currently have 2003 running, so I can't do much more than guess, but my suspicion is that Microsoft decided that the performance hit when tables are linked is too great, and disabled it in 2003.
    Wendell

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

    Re: SubDataSheet (2003)

    I can't explain the discrepancy, but I would set the Subdatasheet Name property to [none] in both the backend and the frontend database (for all tables, preferably.)

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: SubDataSheet (2003)

    Thanks Wendel - I didn't realize there would be a performance hit. The default for 2003 is auto for the subdatasheet name. So I am not sure where Microsoft disabled it. John

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Mt. Olive, North Carolina, USA
    Posts
    170
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: SubDataSheet (2003)

    Thanks Hans - I will change them from auto to none to avoid a slow down.
    John

Posting Permissions

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