Results 1 to 12 of 12
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sub datasheet default settings (Win XP Access 2003)

    I am trying to turn off the subdatasheet function in a table. From table properties, I set subdatasheet name to none, and close and save the table. Then, when I re-open the table, the name is set back to Auto. What can I do to keep the None in place?

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

    Re: sub datasheet default settings (Win XP Access 2003)

    - Which format is your database in? (Access 2000, ...)
    - Have you installed Office 2003 SP1?
    - Have you turned off "Track name Autocorrect info" in the General tab of Tools | Options... (turning it off is strongly recommended; it is a per database setting)

    Let's try to investigate what the scope of this problem is:

    1. Does this behavior persist after you compact and repair the database?
    2. Does this behavior persist after you have quit and restarted Access?
    3. Does this behavior occur for all tables in this database?
    4. Does this behavior occur for tables in other databases?

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    From a quick test on a couple of machines here...

    I created a new 1 table db and changed the subdatasheet setting to None and saved and closed the table.

    Access 2003 No SP1 the setting does NOT stick with Access 2000 file format
    Access 2003 with SP1 the setting does NOT stick with Access 2000 file format
    Access 2003 with SP1 the setting DOES stick with Access 2002-3 file format
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

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

    Re: sub datasheet default settings (Win XP Access 2003)

    Did you turn off Name AutoCorrect before creating the table? If so, it must be a bug in Access 2003.

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    Good call Hans

    Turning off Name Autocorrect allowed the setting to stick for the Access 2000 format as well (using the Access 2003 SP1 machine)

    I cannot test on a vanilla 2003 install at the moment.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

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

    Re: sub datasheet default settings (Win XP Access 2003)

    Thank you for testing. Let's hope this works for the OP too.

  7. #7
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    After starting to go through your questions I came up with the cause of the problem. The table already had a subdatasheet generated. When I removed the old subdatasheet, then the None selection stuck. Thanks.

  8. #8
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    Nope. I created a new table, and it won't get off the Auto setting. I am going through the other replys to see if something works.

  9. #9
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    If I creat a new table, the default is Auto, and I can't get the None to stick. If I have a table that has a subdatasheet and I remove it, the None sticks. ?? I can

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

    Re: sub datasheet default settings (Win XP Access 2003)

    Not Tools | AutoCorrect Options, but the "Track name AutoCorrect info" option in the General tab of Tools | Options... Keeping this setting turned on can cause all kind of problems.

  11. #11
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub datasheet default settings (Win XP Access 2003)

    The autocorrect thing fixed it. Where did you get that idea from? Should I leave it off permanently?

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

    Re: sub datasheet default settings (Win XP Access 2003)

    Yes, you should turn off the "Track name AutoCorrect info" option, then leave it off. Unfortunately, it is a database-level setting that is ON by default, so you will have to do this for all your databases individually. This option was introduced in Access 2000 and has been known to cause problems such as slow performance, reports losing their printer settings, and even database corruption.

Posting Permissions

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