I accidentally replaced one table with another. What to do?

[Guest]

I was trying to link two tables and I accidentally replaced the info from one
with the other tables info. The information from the first table is gone. How
do I get back the information?

 

[Joseph Meehan]

I was trying to link two tables and I accidentally replaced the info
from one with the other tables info. The information from the first
table is gone. How do I get back the information?

Sorry but you said it, it is gone.

Did you have a backup? We all learn the hard way about backups.

There is a slight chance that a service may be able to recover the data.
Access does not always delete everything until you do a compact. However
the services are not cheap. Most people decide that they can live without
the data or re-key it.

Good Luck

 

[Dirk Goldgar]

I was trying to link two tables and I accidentally replaced the info
from one with the other tables info. The information from the first
table is gone. How do I get back the information?

What *exactly* did you do? Your data is probably gone, unless you have
a backup, but it's conceivable you actually did something else that is
just hiding your data from you.

 

[John Vinson]

I was trying to link two tables and I accidentally replaced the info from one
with the other tables info. The information from the first table is gone. How
do I get back the information?

If you just changed a Link to an external table, you're probably ok -
the link is just a pointer, and changing a link won't affect the data.

As noted elsethread, though, if you actually replaced the table you're
either out of luck, or (at best) out a chunk of cash.

John W. Vinson[MVP]