Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adjusting Defaults In Tools|Options (all)

    In <post#=509844>post 509844</post#>, <!profile=Francois>Francois<!/profile> recommends turning off the default AutoIndexing in Tools|Options.

    I have also seen recommendations for turning off AutoCorrect; turning on Compact On Close; increasing the Most Recently Used list etc, etc.

    Some of these settings - such as those under the Keyboard tab - are largely a matter of personal style. Others can affect Dababase performance.

    For the purposes of gathering selected wisdom into a single thread, what are the expert views on tinkering with the default Tools|Options settings?
    Gre

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

    Re: Adjusting Defaults In Tools|Options (all)

    Here's my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

    View tab: mostly personal preference.
    I show hidden objects, and it's wise to leave system objects invisible.

    General tab: a confusing mix of application-level and database-level settings.
    Track name AutoCorrect info should be turned off. Unfortunately, this must be done in each database. Leaving it on leads to reports their page settings, general slowdown and lots of other problems.
    Compact on Close is a nice option for databases used by one person (including locally installed frontends); it can lead to problems for multi-user databases that are opened and closed frequently.

    Edit/Find tab: again, a mix of application-level and database-level settings.
    I prefer to leave the three Confirm options on for interactive use; you can always suppress the messages when you use code.

    Keyboard tab: personal preference.

    Datasheet tab: same

    Forms/Reports tab: same

    Pages tab: same

    Advanced tab: I prefer to use Access 2000 format, even in later versions. This format is more stable, causes less bloat than 2002/2003 format, and can be used in all versions starting with Access 2000.
    The other settings are best left at their default values.

    International tab: personal preference.

    Spelling tab: same

    Table/Query tab:
    I have set default field size for text to 20, but that's a matter of personal preference.
    Clear the AutoIndex on Import/Create box; it's better to create indexes intentionally instead of letting Access do it automatically.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adjusting Defaults In Tools|Options (all)

    My preferences pretty much mirror Hans's. On the Advanced tab, I make sure the Default open Mode is Shared and Default Record Locking is set to No Locks. In the Spelling AutoCorrect options, I make sure that Replace Text as you Type is turned OFF! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

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

    Re: Adjusting Defaults In Tools|Options (all)

    I work pretty much in line with Hans and Charlotte - a couple of things I do change are the most recent file list which I change to the max of 9, and I insist on all database dates being 4 digits. I work quite a bit with ODBC connected databases, and I do usually tweak the ODBC settings on the Advanced tab to be a bit longer than the default, and if I'm using an Access back-end I make sure record level rather than page locking is used (with ODBC the server controls the locking strategy).
    Wendell

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adjusting Defaults In Tools|Options (all)

    <In the Spelling AutoCorrect options, I make sure that Replace Text as you Type is turned OFF!>

    Is there a way to do this in my db startup procedure like I do with other options like:

    Application.SetOption "Default Record Locking", 0 ' 2 = Edited record only, 0=No Locks, 1=All records

    Thanks, John

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

    Re: Adjusting Defaults In Tools|Options (all)

    As far as I know, this is not exposed in Access VBA.

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

    Re: Adjusting Defaults In Tools|Options (all)

    Yes, I am the least prepared of the Lounge users. Where is the Tools|Options? I can find it in Word and Excel, but in Access I get Tools|Customize, with no Options available.

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

    Re: Adjusting Defaults In Tools|Options (all)

    Do you show full menus? If your Tools menu has a downward chevron (double arrow) at the bottom, click it to display the full menu, there should be an Options... item.
    If it is really missing, select Tools | Customize..., activate the Toolbars tab, select Menu Bar and click the Reset button.

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

    Re: Adjusting Defaults In Tools|Options (all)

    Yes, it was missing, but the Reset deal on the Menu bar fixed it up. Thanks. I don't know how I lost it in the first place.

Posting Permissions

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