phantom tables with _1 and _2 ???

T

Tim

When viewing the relationships in an access DB, why do
some of the tables make duplicates of themselves, but with
a "_1" or "_2" name after them? the odd thing is, even tho
they show up like that in the relationships view, they
don't actually create new tables with those name, they
just appear like that in the relationship view.

any ideas? i can hide them, but they come back sometimes.
Thanks!

also, i've noticed that they reappear every time i save a
table that has relationships attached to it. IE, a table
xxxxxx that has a relationship to table zzzzzz in which a
mystery table xxxxxx_1 will appear.... after hiding
xxxxxx_1, it will reappear when i make a change to table
zzzzzz and save it. i hope that makes sense
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top