Table disappeared but still shows up in forms and queries

[jpl458]

I had a table, Mastertbl3, and during something I was doing that table vanished and was replaced with Mastertbl31 (I think I involuntarily hit the right mouse button.) Mastertbl3 no longer appear in the list of tables, but when I run pre-canned queries they get data from Master tbl3 and display the correct data. The record source for those queries is for Mastertbl3. When I look at the queries in design mode the table is Mastertbl3. And the data in the 2 tables is different. I need to get Mastertbl3 back in the list because it has the correct data and I need to make some minor changes. Anyone seen this before and have a resolution?

 

[GPGeorge]

It sounds like you have two tables, then. One called Mastertbl3 and one called Mastertble31. My guess is that you copied the first one and pasted it in as the same name, but with the suffix "1". Either that or it was imported from some other accdb. That's the more likely because the default name assigned when that happens is the incrementing suffix. Mastertble31, Mastertble32 and so on.

Makes me wonder about Mastertbl3, though. How did that name get assigned? And since it's actually providing data to the query apparently, it's not gone; possibly hidden, though. You can hide tables in the Navigation Pane.

Stop what you're doing with the queries and forms, etc. and clean up the tables and the data in them.

You'll have to figure out which table is the one you want to keep and then make sure all of the data in it is current and accurate in comparison to other straggler tables. I don't know how you validate that because it depends so much on how it all got changed and when.

Start here and make all objects Visible to verify if that was the problem with the "vanished" version of the table.

 

[The_Doc_Man]

I don't understand how that happens unless somehow MatyerTbl3 became HIDDEN. Forms and queries bind to things by name so if you trash an object and its name is gone, no query or form should be able to find it. If you are seeing data when you manually open a query that names the table, it is still there.

 

[gemma-the-husky]

Maybe you renamed it, and all the references auto-updated so everything still works.

Change the table name back. Either it will let you, or it will tell you the object already exists.

 

[jpl458]

It sounds like you have two tables, then. One called Mastertbl3 and one called Mastertble31. My guess is that you copied the first one and pasted it in as the same name, but with the suffix "1". Either that or it was imported from some other accdb. That's the more likely because the default name assigned when that happens is the incrementing suffix. Mastertble31, Mastertble32 and so on.

Makes me wonder about Mastertbl3, though. How did that name get assigned? And since it's actually providing data to the query apparently, it's not gone; possibly hidden, though. You can hide tables in the Navigation Pane.

Stop what you're doing with the queries and forms, etc. and clean up the tables and the data in them.

You'll have to figure out which table is the one you want to keep and then make sure all of the data in it is current and accurate in comparison to other straggler tables. I don't know how you validate that because it depends so much on how it all got changed and when.

Start here and make all objects Visible to verify if that was the problem with the "vanished" version of the table.
View attachment 103766

As you described, it was hidden, but when i reopened the DB it's in the list but low lighted. what does that mean< I can open it, but I don't want to proceed till I am sure that I won't mess things up.

Thanks so much for the quick and accurate response.

 

[The_Doc_Man]

If you tell Access to show Hidden tables, they are low-lighted as you say. But they still exist and can be opened by double-click or by right-click and then Open from the pop-up menu. You would also be able to unhide the table from the pop-up menu, I believe.

 

[jpl458]

If you tell Access to show Hidden tables, they are low-lighted as you say. But they still exist and can be opened by double-click or by right-click and then Open from the pop-up menu. You would also be able to unhide the table from the pop-up menu, I believe.

 

[jpl458]

I can open the table with dbl click or by selecting open in the drop menu from right click. I don't know what or where this pop-up menu is that you mentioned, where I might be able to unhide the table. How can I get it to not be lowlighted