How to delete a database – MS Access 2007

30 pts.
Tags:
Access 2007
Access Database
Microsoft Access
I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

Software/Hardware used:
MS Access 2007
ASKED: February 26, 2010  4:16 AM
UPDATED: July 23, 2010  2:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’m using Office 2010 but you should be able to adapt this answer

Open Regedit and go to

“HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\File MRU”

You will see the list of recently used files. Delete the ones you don’t want. The list will get updated when you open new files and eventually your deleted files will drop off the list.

If I remember right you just need to change the 14 for 12 in the registry path when using Office 2007

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 240210
    NLC, you should try accordingly.
    230 pointsBadges:
    report
  • NLC
    Thank you! :)
    30 pointsBadges:
    report
  • Chippy088
    The file is obviously not there any more, so it is purely because you do not want to see it displayed as opened recently. Why don't you try changing the number of files show in the recents list to 1. in the options/settings menu, then open a database you know is current, then change the number of recent files opened back to the number you want it to show. That will clear out references to deleted files without the danger of playing with the registry. (This works in any version of MS office apps.)
    4,625 pointsBadges:
    report
  • NLC
    Thank you Chippy088. Thats exactly what I was after.
    30 pointsBadges:
    report
  • Chippy088
    Glad to have been of help
    4,625 pointsBadges:
    report
  • CanuckGal
    I followed Chippy008 comments/instructions but the database is still listed. When I click on it, it of course cannot be found. Any suggestions?
    20 pointsBadges:
    report
  • CanuckGal
    Fixed it!! I reinstalled the template from ms.com. working fine now.
    20 pointsBadges:
    report
  • 22007
    create a blank database then go to the main menu (left upper corner )then go to access options (at the bottom of the windows that you just opened)the go to advanced then look for (show this number of recent document )and put -0-  click ok and your done ;)
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following