Solved

Access 2007

Posted on 2011-03-07
4
358 Views
Last Modified: 2012-05-11
My OS is windows 7 and I opened a mdb file and worked on it.  Somehow I had exited Access.  And when I try to go to Access to open the most recent file, the changes that I made were not recorded.  is there any way I can retrieve the file that I was working on with the changes intact.  thank u
0
Comment
Question by:jegajothy
4 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 100 total points
ID: 35061777
No.
Save as you go is the only way to do things.
0
 
LVL 28

Assisted Solution

by:omgang
omgang earned 200 total points
ID: 35061792
When you close an Access database or exit the Access application you are prompted to save any design changes to Access objects that have been modified.  If you clicked No to the prompt, or if Access was terminated in such a way that you did not receive the prompt, then you won't be able to recover your changes.
OM Gang
0
 
LVL 9

Accepted Solution

by:
damerval earned 200 total points
ID: 35061826
The only way I can explain the behavior you are experiencing is that you are somehow working on two copies of the same file.
Do a search on your hard drive for MDB files and I will venture to guess that one of those files has your changes.
Access does not overwrite data the way Word or Excel do. the good news is you probably haven't lost any data. The bad news is you will most likely have to move it from one file to another.

Philippe
0
 

Author Closing Comment

by:jegajothy
ID: 35062974
thank u
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

920 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

16 Experts available now in Live!

Get 1:1 Help Now