So here's the situation. In our office, we have 2 different computers accessing the same Access database. We use an email marketing program with that database. If a person unsubscribes from our email, we can let the email program know what email to exclude in the future. But we would have to do that on both computers (which wouldn't happen do to office communication breakdown).
Is there a way to leave the entry in the database but not allow other software to see that entry? I can't delete the entry because the database updates come from another source and that source would still have that entry (thus putting the entry back in).