Solved

How to clear recent database history in access 2007

Posted on 2009-05-13
8
1,857 Views
Last Modified: 2012-05-06
How do I clear my recent history in office 07?
0
Comment
Question by:kenfitzgerald
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24375565
0
 

Author Comment

by:kenfitzgerald
ID: 24375609
This looks like it's good for word, excel, and powerpoint. Do you have one for Access?
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24375687
Did you try following the same logic?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:kenfitzgerald
ID: 24375709
yes I looked through the options and didn't find the show number of recent docs option.
0
 
LVL 44

Accepted Solution

by:
GRayL earned 500 total points
ID: 24376625
Click Tools, Options, General, and set the size of Recently Used List to 0.  However, remember, that a savy user can reverse that setting to anything from 1 to 9.  The 9 most recently used database files for Access are automatically stored in:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Settings - as MRU1 thru MRU9.  The size setting just tells the system how much of that list to show.  I suppose you could empty each of those entries, by using RegEdit - but that is only for the knowledgeable user.  Before trying anything with RegEdit, make sure you have a safe, current, and secure backup of your mdb.  
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24376660
BTW, I don't have 2007, so I am using A2003 to 'guess' the outcome for A2007.  I see from the reference is says to click the Advanced tab, however, the size option in A2003 is under the General tab.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 24376754
Thanks, glad to help.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24376796
Office tools > access options > advanced > recent doc
set the value of the drop down to 0
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question