I've been maintaining a database for a while now (Access 2010), and there's something odd going on that I can't find any information about...
When I open up my relationship window, there are 2 tables that have been mysteriously linked to copies of themselves that are always displayed when the parent table is, and another "copy" table that displays with its related table. They display as "tbl(Name)_1" when the real table is "tbl(Name)" - just as if I'd opened them twice while tinkering with my relationships.
I've tried hiding them and saving the layout, but after closing and reopening the Relationship window they show up again.
I had another strange issue today: I wasn't allowed to change the data type for a certain field because it was on one of these "ghost tables" that I hadn't removed that specific relationship for yet (the field i was trying to change relates a couple tables).
There are 2 ideas I have of why this could be happening:
1) I did acidentally open the same table twice a few times, which would explain the copies, but not why they aren't going away and definitely not why they are being treated as real tables. This could just be something about how the Relationship display functions that I don't know - aka there's a way to remove them permanently, but I can't find any information about it easily.
2) When more of these copies showed up today that weren't there before, I became concerned it could be data corruption. I'm not entirely sure how to test this theory, though, and not excited about the prospect of fixing it should it be the case.
If anyone has experienced something like this, or knows what is going on, please help....
When I open up my relationship window, there are 2 tables that have been mysteriously linked to copies of themselves that are always displayed when the parent table is, and another "copy" table that displays with its related table. They display as "tbl(Name)_1" when the real table is "tbl(Name)" - just as if I'd opened them twice while tinkering with my relationships.
I've tried hiding them and saving the layout, but after closing and reopening the Relationship window they show up again.
I had another strange issue today: I wasn't allowed to change the data type for a certain field because it was on one of these "ghost tables" that I hadn't removed that specific relationship for yet (the field i was trying to change relates a couple tables).
There are 2 ideas I have of why this could be happening:
1) I did acidentally open the same table twice a few times, which would explain the copies, but not why they aren't going away and definitely not why they are being treated as real tables. This could just be something about how the Relationship display functions that I don't know - aka there's a way to remove them permanently, but I can't find any information about it easily.
2) When more of these copies showed up today that weren't there before, I became concerned it could be data corruption. I'm not entirely sure how to test this theory, though, and not excited about the prospect of fixing it should it be the case.
If anyone has experienced something like this, or knows what is going on, please help....
