I have a database that has a form added for the users to import updates from another database without me having to do it manually. It looks for a DBASE IV file that is placed in a shared directory on a server and imports it into the Access DB. I have a relationship set on this table in the Access DB and when I try to import this update I am told that I can not because of the relationship.
Is there a way to do this? It is important to be able to delete the existing table in the Access DB and completely replace it with this new import update.
Thank you.