Database Crashed, lost work

The database that I built is getting moved to sharepoint so that we are able
to access it everywhere, not just on our LAN. I put about 8 hours of work
into it last night and every time that I changed something I closed window
and saved changes. At around 1:30 am there was a critical error and access
2007 has to close. I thought, shoot I am going to lose a good 10 mintues of
work on the form I have open. The entire database reverted back to the
original database. Any idea how I can get any of the changes I made. Once
again, I saved constantly throughout my work, but adminitly never exited the
database and came back in.

Now you know that you should exit periodically and use windows explorer to
make a backup copy of your database application.

I suspect that if your changes are gone, then they are gone and the only way
to get them back is to redo them.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Jphillip wrote:
The database that I built is getting moved to sharepoint so that we are able
to access it everywhere, not just on our LAN. I put about 8 hours of work
into it last night and every time that I changed something I closed window
and saved changes. At around 1:30 am there was a critical error and access
2007 has to close. I thought, shoot I am going to lose a good 10 mintues of
work on the form I have open. The entire database reverted back to the
original database. Any idea how I can get any of the changes I made. Once
again, I saved constantly throughout my work, but adminitly never exited the
database and came back in.

Are you sure that you looked at the same copy of the database? Try checking
your machine(s) for another copy by the same name, and any other Access file
made near that time of day.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jphillip" wrote in message
...
The database that I built is getting moved to sharepoint so that we are
able
to access it everywhere, not just on our LAN. I put about 8 hours of work
into it last night and every time that I changed something I closed window
and saved changes. At around 1:30 am there was a critical error and access
2007 has to close. I thought, shoot I am going to lose a good 10 mintues
of
work on the form I have open. The entire database reverted back to the
original database. Any idea how I can get any of the changes I made. Once
again, I saved constantly throughout my work, but adminitly never exited
the
database and came back in.