Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What to you get if you do Select *
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
Are you using an Access View or a physical table? Check whether the view returns any data and check the view's definition.
i am using a query (not a table). the query in Access does return data.
what do you mean by check "view's defenition"?