Solved

How to clear recent database history in access 2007

Posted on 2009-05-13
8
1,667 Views
Last Modified: 2012-05-06
How do I clear my recent history in office 07?
0
Comment
Question by:kenfitzgerald
  • 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
 

Author Comment

by:kenfitzgerald
ID: 24375709
yes I looked through the options and didn't find the show number of recent docs option.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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 119

Expert Comment

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

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

919 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now