Copies of Table with Arrow Icons

T

TinaF

I have a table called Quotes2004. Somewhere along the line two
additional tables appeared called Quotes20041 and Quotes20042, each
with an arrow icon next to them.

I understand that the arrow indicates a link. But, I don't recall
making these table copies. Can some process make the copies
automatically?

As far as I can tell, they are exact copies of Quotes2004 and they are
updated when I update Quotes2004.

How can I determine how these were created, what the links are and if
they are really necessary?
 
A

Allen Browne

To discover what a table is linked to, open it in design view.
Then open the Properties sheet, and look at the Description property.

Alternatively, open the Immediate Window (Ctrl+G), and enter:
? CurrentDb.TableDefs("Quotes20041").Connect

These links should not be created by accident. The Properties of the linked
table may give you a clue when it was created.
 
Top