data from MS Access query is missing

[#1]

Hi,

I am facing a strange problem. I am connecting to my MS Access using CONNECT32 and the connection is successful.
I am able to select my query and can see the fields name

my query:

but the issue is that the data is missing:

(when I tried it with other table from the same DB it works fine and I can see the data)

the query is not corrupted as I can see the query's data in access .

do you know how can I solve it?

thanks,

Mayan

[m_woolf]

What to you get if you do Select *

[#3]

this is what i am writting:

CONNECT32 TO [MS Access Database;DBQ=C:\Users\Mayan\Aitan\תוכנת בית אריזה\תוכנת_בית_אריזה - 2015.accdb];
LOAD `Receive_ID`,
`Peak_year`,
ReceiveDate,
`Grower_ID`,
`Rec_Delivey_Num`,
PlotName,
FruitType,
DealName,
`Pack_Type`,
`Pack_Qty`,
`TotalWeight_Bruto`,
EnteringDate,
EnteringTime,
`First_Price`,
`Second_Price`;
SQL SELECT *
FROM `Copy Of ZZ_Rec_QV`;

but when i do reload the tables i receive are empty (although the query isnt empty in the access)

double click on the following also prvide no data (when i click on a table i do receive data)

please advise

Thanks,

Mayan

[jonathandienst]

Are you using an Access View or a physical table? Check whether the view returns any data and check the view's definition.

[#5]

i am using a query (not a table). the query in Access does return data.

what do you mean by check "view's defenition"?