Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2008
    Location
    New Jersey, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Does anyone know how to remove an item from the recently accessed database list on the opening screen of Access 2007 ?? For example if you open a database from a flashdrive it puts it in the list, yet you may never use that file again. Thanks for your help.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    This issue affects most Microsoft Office applications, not just Access. And as far as I know, there is no designed method for removing a file from the list. I suspect there may be a special file that contains those settings, or entries in the Registry - but I concluded long ago it wasn't worth messing with. If you find it really frustrating, you could set the number of recent files displayed to 0 in Access Options.
    Wendell

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    You can edit the registry, or use an API to change the registry entry
    You would be looking for File Name MRU Keys

    In Office 2003 it would be at


    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\C ommon\Open Find\Microsoft Office Access\Settings\Open\File Name MRU

    For 2007

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\Open Find\Microsoft Office Access\Settings\Open\File Name MRU

    At least that is what Microsoft say

    Andrew

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I can you you how to prevent an item appearing in the recently used file list at all. (This happens to me all the time even though I find it a nuisance.)
    • Open Access 2007 and open a db
    • Open a second instance of Access 2007 and open a 2nd db (db2)
    • Close the second instance,
    • Close the first instance.
    db2 does not appear in the recently used file list!
    Regards
    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
  •