Results 1 to 8 of 8

ODBC problem

  1. #1
    SColaux is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    5

    ODBC problem

    Hello,



    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.

    Many thanks,

    SColaux

    (sorry for bad english)

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,766
    be sure you have the latest ODBC driver for your BE, THEN link the tables.

    access only shows a few 1000 records to save memory, the query should still pull all data tho.

  3. #3
    SColaux is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    5
    Quote Originally Posted by ranman256 View Post
    be sure you have the latest ODBC driver for your BE, THEN link the tables.

    access only shows a few 1000 records to save memory, the query should still pull all data tho.
    Already check all the drivers I'm using and futhermore, only two day passed between the try on Acces 2016 free and Access 2016 paid.

    Many thanks

  4. #4
    ssanfu is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    6,230
    Which ODBC driver are you using?
    I couldn't read data from SQLSE using SQL Server driver. I had to use SQL Native Client/SQL Native Client 10.0 (Access 2010).
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  5. #5
    SColaux is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    5
    Quote Originally Posted by ssanfu View Post
    Which ODBC driver are you using?
    I couldn't read data from SQLSE using SQL Server driver. I had to use SQL Native Client/SQL Native Client 10.0 (Access 2010).
    Hello,

    I tried with SQL Server Native 10.0 and 11.0, ODBC Driver 11 for SQL and SQL Server 10. Same problem for all of them

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,766
    aaahhh 2016. The bug version.

  7. #7
    SColaux is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    5
    Quote Originally Posted by ranman256 View Post
    aaahhh 2016. The bug version.
    Doesn't change the fact that with the free version I had access of the data and when I bought it, it change !

  8. #8
    SColaux is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    5
    Quote Originally Posted by SColaux View Post
    Doesn't change the fact that with the free version I had access of the data and when I bought it, it change !
    To anyone who get the same problem,

    The 2016 version I had free was a Click 2 Run edition (v16.7.XX)
    The 2016 version I bought is a MSI version (v16.4.XX)

    The 16.7 add a new feature the allows Access to process huge table with a BigInt primary key, this feature will be added in June 2017 for the MSI version.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2015, 08:44 AM
  2. Access front-end database ODBC problem
    By cuddles in forum Access
    Replies: 0
    Last Post: 07-31-2014, 11:47 AM
  3. Replies: 6
    Last Post: 08-17-2013, 11:47 PM
  4. Replies: 5
    Last Post: 10-25-2011, 07:01 AM
  5. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 08:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums