Solved

Access 2007

Posted on 2011-03-07
4
359 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

776 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