×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Lotus deleted almost all of my entries

Lotus deleted almost all of my entries

Lotus deleted almost all of my entries

(OP)
Inthe office I work at, there is a main database of all our customers. I needed to send out a mailing to a specific group of these customers. I thought the easiest way to narrow down the mailing would be to:
-Make a copy of the database from another computer on the network onto my pc and RENAME it,
-run searches for duplicate entries (names, addresses) and delete all but one of each duplicate
-search the remaining entries for the criteria I needed and print labels.

The problem is that Approach deleted the duplicates in BOTH databases, the MAIN one that everyone uses AND the copy I maddeon my PC. Why would this happen? This is very bad. I guess I have to give up on trying to retrieve the old data. what can I do to avoid this in the future???

RE: Lotus deleted almost all of my entries

I would guess that the database could have been joined to others.  When you copied the database, the joins remained intact.
This could explain why they were all deleted.
Depending on how often you need to do this, I would probably export the information into a spreadsheet and then manipulate it as required.
(Probably not the best solution, but it certainly works for me!!)

As for retrieving the data, the only way I would know of is to check with your IT support to see if they have backups of the required database.
Our IT support takes backups every night.  If we need something restored, we just give them a date and file location and they do the rest. (obviously you lose any changes made since that date)

Good luck.

I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close