Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Name AutoCorrect (A2K)

    I just finished reviewing the MSDN list of known problems with 'Name AutoCorrect' in A2K.

    1) Is it advisable just to turn the darn thing off -- even if SR-1 is installed?

    2) If I develop with Name AutoCorrect on, on a machine with SR-1 installed, and then transfer an MDE to a machine without SR-1, could problems still occur?

    TIA
    Donald

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Name AutoCorrect (A2K)

    FWIW one of the first things I do with any new database is turn off the Name Autocorrect, even though I have SR1a installed. Call me cynical.
    As regards 2, I don't know but I don't think I'd take the risk.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Name AutoCorrect (A2K)

    Name AutoCorrect is turned off or on for each *database*, so if you turn it off and create an MDE, then it stays turned off for that MDE, regardless.

    And yes, turn it off, even if you have SR1 installed. That didn't seem to cure all it's strangeness, and you don't need the bloat it creates. If you transfer a database to a non-SR1 machine, you'll probably run into problems anyhow (like the print settings). Turning off Name Autocorrect will at least eliminate one of them. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name AutoCorrect (A2K)

    If I have been running with it on, is there any way to "clean out" my mdb after I turn it off? Or do I have to do the "import into a new db" number?

    Thanks
    Donald

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

    Re: Name AutoCorrect (A2K)

    Just turning it off and then compacting is all I can suggest. In extreme cases, do a <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=44732&page=& view=&sb=&o=&vc=1#Post44732>decompile</A> and then compact to squeeze maximum space out of the database.
    Charlotte

Posting Permissions

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