Well, even a senior DBA has to add [schema name]

I just reproduced your issue.

When I ran on one of my databases

select top 1 * from [my database].[my table]

I got the identical error message about invalid object

When I ran

select top 1 * from [my database].dbo.[my table]

I got a valid query result.

It may be that you have not decribed the issue correctly and you mean to say, that you used USE [db name]

and then in select you mean to say

[schema name].

but as presented with XXX you say,

USE XXXX

and then

select .... from XXXX.XXXXX

so in your description the schma name is missing.

Yelena