How can I revert to a previous auto saved Access file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I deleted a column in a table and was unable to undo the action. How can I
restore or revert to yesterday's automatically saved Access database file, so
that although I lose today's work, I don't lose all of the information in the
whole column?
 
I deleted a column in a table and was unable to undo the action. How can I
restore or revert to yesterday's automatically saved Access database file, so
that although I lose today's work, I don't lose all of the information in the
whole column?
Click to expand...

What (or who) saved the file yesterday? If it's done through a backup program, then you might need to restore it from
that program's interface. If it was just a simply copy/paste, then you may be able to just import the table from the
copied file. This would overwrite the existing table, of course.

To import the table, first rename it in your current database, then click File - Get External Data - Import and follow
the prompts.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Access MDB doesn't have a backup and restore functionality

you need to move to SQL Server
 
SQL Server has the concept of 'database snapshits'

this is a much much much simpler concept than copying and pasting MDB files
by hand


Scott McDaniel said:
What (or who) saved the file yesterday? If it's done through a backup
Click to expand...
program, then you might need to restore it from
that program's interface. If it was just a simply copy/paste, then you may
Click to expand...
be able to just import the table from the
copied file. This would overwrite the existing table, of course.

To import the table, first rename it in your current database, then click
Click to expand...
File - Get External Data - Import and follow
Click to expand...
 
Back
Top