So I came back from lunch today to find that my idiot of a parter had imported an excel file into 5 fields in our database. The problem is that he did it incorrectly and it replaced the 5 fields with the new data (which he meant to add to it) AND it also replaced some first name/last name things incorrectly! Of course our backup copy is more than a month old and would require HOURS and HOURS of re-entering the data to fix it on our own. Any help as to being able to recover a version that we saved this AM would be eternally grateful!

I hope you are using a unique ID? If so, do this:

Show All Records

Import (UpDate Matching Records In Found Set]

... do NOT select Add remaining records.

Match ID to ID and select 'Match Records Based on this field'

Select ONLY the fields you need to replace for the import - the ones messed up

Back up first in case you have a problem and have to re-do it. And repeat three times ... 'Never let Users import unless it's scripted and protected.'

vs. 8 is wonderful because you can provide Users with ONLY fields to map to according to what is on a layout. In the 'old days' they had access to EVERY field including the unique ID. Now you can restrict what they see. But I STILL use an intermediate import table so I can control what happens. It is far too easy for them to map to incorrect fields. Usually, I script the import and lock them totally out.

UPDATE: Old backup? Oh dear. Well, any changes to firstName, lastName since then will be lost unless you can isolate WHICH records were changed.

LaRetta

Edited February 21, 200619 yr by Guest
Added UPDATE

Thanks LaRetta!! One more question... How can I UNSELECT the auto save option that my idiot partner selected the first time he used FM? I want to be able to see the mistakes before it is automatically saved when we close it, etc.