When I try to get data view in access is empty

Hello, I have the problem that when I try to bring data from a view of an access database, it appears empty but if I see it in access it has data, which I have to do to keep data.

I notice that the view is the result of another view with a table that is created with a macro, but the table is created and the view it refers to works well and that of that view if I can observe the data.

Thanks you,

Fabián.