May 6, 2015 at 2:05 pm
I have a situation where the .mdb file no longer exists. I have the output created by the data within the database using mail merge. There are about 150 names & addresses that make up this list/labels. Is there a way to use the output as the data source to populate a new .mdb file?
I know there is a way to manually place this data into a new database using the wizard but I am looking for the better way if possible to restore that database.
May 6, 2015 at 2:37 pm
Since the database no longer exists, you have two options: 1) Restore it from a backup (are you backing things up? If not you should be), or 2) Import the data into a new table in a new empty database with the same name that existed previously. (If you only have it as labels or word documents, the import is going to be ugly, but if you have it in a table in Word, in delimited text format, or in Excel, the import is pretty easy. Otherwise you might as well re-enter the data in a new database.)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 29, 2015 at 9:16 am
Before attempting to revover data from a damaged .mdb file, consider that you may still have the option of recoving a previous version of the file intact. From Windows Explorer, right click on the file and choose the option 'Restore previous versions', which hopefully will list at least one version to restore form.
Depending on your version of Windows, if the restore from shadow copy option isn't available, then there is a free tool to assist with this.
From time to time, Windows Vista / 7 / 8 creates point-in-time copies of your files. This allows you to retrieve older versions from files you accidentally deleted or altered. This service is turned on by default on all versions of Windows Vista/7, but Microsoft grants access to these copies only in Ultimate, Business, and Enterprise editions. This is where ShadowExplorer comes into play.
http://www.shadowexplorer.com/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply