Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How can I delete database in the Open Recent Database list

Discussion in 'Information Technology' started by Gear, Jul 28, 2006.

  1. Gear

    Gear
    Expand Collapse
    Guest

    Access 2007
    I got 4 databases that was deleted and now they still appear in the "Open
    Recent Database" list

    How can I do a clean up in this list
     
  2. Loading...


  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    I don't know of any "official" way to do this, but you can hack the list in
    the registry editor:

    Start > Run > "regedit"

    Go to HKEY_CURRENT_USER\Software\Microsoft\Office\<your
    version>\Access\Settings
    (where <your version> is 11.0, 10.0, 9.0, etc)

    Delete the key values named MRUx which correspond to the files that no
    longer exist.

    You must close Access first, otherwise the list will be recreated.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Gear" <Gear@discussions.microsoft.com> wrote in message
    news:05EBB6A2-4BC4-4E37-965C-BC849431F6DD@microsoft.com...
    > Access 2007
    > I got 4 databases that was deleted and now they still appear in the "Open
    > Recent Database" list
    >
    > How can I do a clean up in this list
    >
     
  4. Smartin

    Smartin
    Expand Collapse
    Guest

    Gear wrote:
    > Access 2007
    > I got 4 databases that was deleted and now they still appear in the "Open
    > Recent Database" list


    Yes, they are "most recently used" (MRU) files. This list has no
    knowledge of file name changes or deletions, only that you opened then
    at one time or another. MRU is common to many Windows applications.
    MRU's are stored in the registry in a key specific to the application.

    > How can I do a clean up in this list


    Three solutions ...

    Open any MDB file. In Tools | Options | General, change the "Recently
    Used File List" setting to 0. Close Access and reopen any MDB. Change
    the "Recently Used File List" as needed to a preferred setting. (Note:
    This will blow away any MRU's you might want on hand, but see next
    solution for how to repopulate the list).

    Open up to 9 distinct existing MDB's you would like on hand, depending
    on your setting for "Recently Used File List" in Tools | Options |
    General. This will flush old entries.

    Edit the registry on your PC as instructed in a recent post by Mr.
    Douglas Steele. Extreme care is always advised whenever the registry is
    touched.
    http://groups.google.com/group/microsoft.public.access/msg/f26c63b3962b6809?hl=en
    (message ID = eMx$p30qGHA.4676@TK2MSFTNGP03.phx.gbl)

    HTH
    --
    Smartin
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Gear wrote:
    > Access 2007
    > I got 4 databases that was deleted and now they still appear in the
    > "Open Recent Database" list
    >
    > How can I do a clean up in this list


    I know I had a utility that did that, as well as a lot of other things.
    Google around and I am sure you will find such a utility. Names like "Shred
    It" would be good chances. Look for security or private keywords.

    Of course since you have already deleted the files, why worry? It is
    just a list. They will go away as you open and use new files. They will
    not hurt anything and if you try to open one it will just tell you it is
    gone.

    --
    Joseph Meehan

    Dia duit
     
  6. Smartin

    Smartin
    Expand Collapse
    Guest

    Joseph Meehan wrote:
    > Gear wrote:
    >> Access 2007
    >> I got 4 databases that was deleted and now they still appear in the
    >> "Open Recent Database" list
    >>
    >> How can I do a clean up in this list

    >
    > I know I had a utility that did that, as well as a lot of other things.
    > Google around and I am sure you will find such a utility. Names like "Shred
    > It" would be good chances. Look for security or private keywords.
    >
    > Of course since you have already deleted the files, why worry? It is
    > just a list. They will go away as you open and use new files. They will
    > not hurt anything and if you try to open one it will just tell you it is
    > gone.
    >


    FWIW AdAware will remove MRU's too if configured to do so, but it's global.

    --
    Smartin
     
  7. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    To expand on Graham's unofficial hack, you can save the indicated branch of
    the registry to a new .reg file. Then open it with NotePad and hack out
    everything that you don't want to reset. Set each MRU to zero lenght strings.
    I just tried this on my PC, which has Windows 2000 and Access 2003, and it
    worked fine. Here is the resulting contents of my "ClearAccessMRUList.reg"
    file. Rather than copy this one, I suggest starting by backing up your
    registry branch first. Make another copy of the .reg file to edit. The first
    copy can be used to restore, just in case anything terrible happens.

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Settings]

    "MRU1"=""
    "MRU2"=""
    "MRU3"=""
    "MRU4"=""
    "MRU5"=""
    "MRU6"=""
    "MRU7"=""
    "MRU8"=""
    "MRU9"=""


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________


    "Graham Mandeno" wrote:

    > I don't know of any "official" way to do this, but you can hack the list in
    > the registry editor:
    >
    > Start > Run > "regedit"
    >
    > Go to HKEY_CURRENT_USER\Software\Microsoft\Office\<your
    > version>\Access\Settings
    > (where <your version> is 11.0, 10.0, 9.0, etc)
    >
    > Delete the key values named MRUx which correspond to the files that no
    > longer exist.
    >
    > You must close Access first, otherwise the list will be recreated.
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Gear" <Gear@discussions.microsoft.com> wrote in message
    > news:05EBB6A2-4BC4-4E37-965C-BC849431F6DD@microsoft.com...
    > > Access 2007
    > > I got 4 databases that was deleted and now they still appear in the "Open
    > > Recent Database" list
    > >
    > > How can I do a clean up in this list
    > >

    >
    >
    >
     
  8. Gear

    Gear
    Expand Collapse
    Guest

    Hey guys, this is more like on Microsoft side to do something like a
    contextual menu to manage this list or simple automaticly check if the file
    still exist and just get rid of it since its just the list of recent open
    files

    Since its Office 2007 beta, I was just hoping that a Microsoft Office team
    would read this mail then just do 1 or 2 lines of code to do something to
    improuve their product. I know it is VERY simple since I'm a 25 years
    programmer experience :)

    Thank you for all your replay but I knew about all that registry crap we can
    do.

    "Gear" wrote:

    > Access 2007
    > I got 4 databases that was deleted and now they still appear in the "Open
    > Recent Database" list
    >
    > How can I do a clean up in this list
    >
     
  9. Smartin

    Smartin
    Expand Collapse
    Guest

    Gear wrote:
    > Hey guys, this is more like on Microsoft side to do something like a
    > contextual menu to manage this list or simple automaticly check if the file
    > still exist and just get rid of it since its just the list of recent open
    > files
    >
    > Since its Office 2007 beta, I was just hoping that a Microsoft Office team
    > would read this mail then just do 1 or 2 lines of code to do something to
    > improuve their product. I know it is VERY simple since I'm a 25 years
    > programmer experience :)
    >
    > Thank you for all your replay but I knew about all that registry crap we can
    > do.
    >
    > "Gear" wrote:
    >
    >> Access 2007
    >> I got 4 databases that was deleted and now they still appear in the "Open
    >> Recent Database" list
    >>
    >> How can I do a clean up in this list
    >>


    And while you're at it, how about being able to save more than 9 MRU's?
    Can you put that in too? (^:

    --
    Smartin
     
  10. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    So if you were temporarily disconnected from a network resource, would you
    want Access to clear the MRU list when opening simply because it couldn't
    find the files? I dunno...sounds to me like more delay required to get Access
    open each time. I can live with the MRU just as it is.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________


    "Gear" wrote:

    > Hey guys, this is more like on Microsoft side to do something like a
    > contextual menu to manage this list or simple automaticly check if the file
    > still exist and just get rid of it since its just the list of recent open
    > files
    >
    > Since its Office 2007 beta, I was just hoping that a Microsoft Office team
    > would read this mail then just do 1 or 2 lines of code to do something to
    > improuve their product. I know it is VERY simple since I'm a 25 years
    > programmer experience :)
    >
    > Thank you for all your replay but I knew about all that registry crap we can
    > do.
    >
    > "Gear" wrote:
    >
    > > Access 2007
    > > I got 4 databases that was deleted and now they still appear in the "Open
    > > Recent Database" list
    > >
    > > How can I do a clean up in this list
    > >
     

Share This Page