Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to clear recent database history in access 2007

Posted on 2009-05-13
8
Medium Priority
?
1,988 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

886 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