5 Replies Latest reply on Jun 12, 2009 11:38 PM by Ice72

    FM10 AdvSrv - ODBC problem

    Ice72

      Title

      FM10 AdvSrv - ODBC problem

      Your post

      Hi,

       

      I'm trying to connect from a Windows PC, with Microsoft access 2000, to a FM10 srv.

       

      I have enable ODBC on FM10, installed the driver on client, configured it ad granted "ODBC R/W" on my FM test file.

       

      If I have linkd the table from access, without specifing any primary key (when requested from access), so I see all my

      records (but limited to a read-only view, due to the PK missing mapping).

       

      If I relink the table specifing which is the PK (an auto-inc integer called "id"), access link the table, but when

      I double click on it I can only see a grid filled with a lot of "#Name?" strings (but whith the correct columns and

      number or rows)  and a pop up window which told me a generic "ODBC: call failed".

       

      Note: if I don't map the PK access doesn't allow me to update/delete/insert records ... :(

       

      Any Idea?

      TIA