How can I delete database in the Open Recent Database list

#1 (**permalink**) 28-Jul-2006, 08:40 AM

Access 2007
I got 4 databases that was deleted and now they still appear in the "Open
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13854-how-can-i-delete-database-open.html
Recent Database" list

How can I do a clean up in this list

*

#2 (**permalink**) 28-Jul-2006, 08:40 AM

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\Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
version>\Access\Settings
(where 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" wrote in message
news:05EBB6A2-4BC4-4E37-965C-BC849431F6DD@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> 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
>

#3 (**permalink**) 28-Jul-2006, 08:40 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
touched.
http://groups.google.com/group/micro...962b6809?hl=en
(message ID = eMx$p30qGHA.4676@TK2MSFTNGP03.phx.gbl)

HTH
--
Smartin

#4 (**permalink**) 28-Jul-2006, 08:40 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
gone.

--
Joseph Meehan

Dia duit

#5 (**permalink**) 28-Jul-2006, 08:40 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> 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

#6 (**permalink**) 28-Jul-2006, 08:41 AM

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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
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\A ccess\Settings]

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

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.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\ > version>\Access\Settings
> (where is 11.0, 10.0, 9.0, etc)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
>
> 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" 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
> >
>
>
>

#7 (**permalink**) 28-Jul-2006, 08:41 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
programmer experience

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

"Gear" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> 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 (**permalink**) 28-Jul-2006, 08:41 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> still exist and just get rid of it since its just the list of recent open
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
> 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

#9 (**permalink**) 28-Jul-2006, 08:41 AM

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/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13854
__________________________________________

"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
> >