How can I delete database in the Open Recent Database list

[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

 

[Graham Mandeno]

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.

 

[Smartin]

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 = [email protected])

HTH

 

[Joseph Meehan]

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.

 

[Smartin]

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.

 

[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
__________________________________________

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

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

 

[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.

 

[Smartin]

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.

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

 

[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
__________________________________________