Hey, all!
I'm using Access 2013 and trying to run a simple DELETE query on a table in another database, but because of attachment fields, the query errors out (Cannot reference a table with a multi-valued field using an IN clause that refers to another database). I would really love to keep the attachment fields, although I wish there was a way to limit them to one attachment to avoid this problem.
So... is there a way to delete records in another database table with multivalued fields?
I'm using Access 2013 and trying to run a simple DELETE query on a table in another database, but because of attachment fields, the query errors out (Cannot reference a table with a multi-valued field using an IN clause that refers to another database). I would really love to keep the attachment fields, although I wish there was a way to limit them to one attachment to avoid this problem.
So... is there a way to delete records in another database table with multivalued fields?