Duplicate Tables in MS Access

Question

I am baffled.

I have been using MS Access for years and thought I was good at it. I have come across an issue today though which I cannot solve.

There is a central Table in my database called "Data", with all of the my relationship tables linking into it. 

Today I added a new relationship table and managed the relationships as usual. When running a query though, it appears that the original 'Data' table has been duplicated in the background. When I tried to run a query it told me that I had to specify which table a particular field came from. (Image one) It was originally only in the main Data table.

Looking at a query, I can see when I try to amend a field there are now 4 additional "Data" tables that I can choose, but I cannot find them anywhere to delete them. (Image two) Any ideas?

I have attached the two screenshots that illustrate the issue.

Answer 1

This may be a simple matter of expanding the table pane in Query Design View. Look at the screen shot, there is a thick line above the grid with several dots in the middle. Position the cursor on that line until it becomes a two headed arrow, then drag it down. that should show the table pane. You can then right click  on the aliases and choose remove.

Answer 2

I don't see your Tables in the designer view. You may be having a similar issue to another poster, where they could not see the tables and relationships. I believe the "fix" for that was to ensure your Office is updated fully.

You can switch over to SQL view and remove the aliased tables. If you show the SQL of your query we can tell you what to remove.

Answer 3

Scottgem , this worked thank you. Didn't even know I could expand that pane. Great tip.

Scott McDaniel thanks also