How to find an object in a mdb

[CarlotaVina]

Hello everyone,



I have a object in a mdb's query. How can I find this object in the mdb?. I don't find it neither tables nor queries.

Thanks in advance

Carlota

[June7]

Post the SQL statement.

Access does not have capability to search its structure. This requires building your own code to search or installing third-party app like Rick Fisher's Find & Replace or V-Tools.

[CarlotaVina]

Thanks you for the reply.

In the query design view , How can I see the source of the table?. Currently is empty.

Thanks in advance

[aytee111]

What is empty? If there is a table on the top portion of query design and it is showing no fields, that means that Access can't see the table. It is a linked table? To test this, open the table from the database window and see what occurs.

[orange]

Carlota,

Please try again to describe your issue in simple terms. Your issue is not clear to readers.
Provide a jpg of your screen/issue as an example to show the problem.

[CarlotaVina]

Thanks you for the reply

Attached the jpg

The first jpg shows the query design. I can't open the table DIASODCA because doesn't exist neither tables or queries.




The second one show table properties.




Thanks in advance

[aytee111]

Basically it does not exist any more, it has been deleted. No way to tell whether it was a query or a table from here. You will need to go to a previous backup/older version of the database to find it.