To anyone who can help me, I explain my problem :
I need to reed a table from a SQL serv via ODBC. Here are the results :
- With Access 2013 : not working, all data are #Deleted
- With Access 2016 free version of 5 days, was on PC when I installed windows) : working fine
- With Access 2016 (pro, 64bits) : not working, same problem (#deleted)
The question : why was it working with the "free" version and not with the one I bought ? I did EXACTLY the same things (link ODBC, read only, ...) but can't look the options of the free one due to the installation of 2016 Pro.
NB : I notice that on the free version, Access didnt load all the data but just the first 1000 raws or so, nevertheless I was still able to make request on the whole table and obtain results. A contrario, on the paid version Access load all the data and cant read it.
NB2 : The SQL data contains more than 55000000 lines and 100 raws, ~3GB of data.
(sorry for bad english)