5 Replies Latest reply on Jul 11, 2009 12:19 AM by Ice72

    Access 2000 / ODBC - FM10AdvSrv

    Ice72

      Summary

      Access 2000 / ODBC - FM10AdvSrv

      Description of the issue

      Hi, I'm trying to connect from a Microsoft Access 2000 to a FM10AdvSrv. If I connect WITHOUT specifying PK (on access request) I can see all records of my table "A".But if I specify the Primary Key access show me a grid with a rows number equals to thetable's records number, but all cells are set to "####" (access error notification). Note that if I doesn't declare the PK access doesn't allow me to update/ins/delete records. The table "A" have 3 fields:- "id": auto-inc/primary key- "t": text- "v": value Thanks for any patch!

        • 1. Re: Access 2000 / ODBC - FM10AdvSrv
          TSGal

          Ice72:

           

          Thank you for your post, and I apologize for the late reply.

           

          What is the SQL statement sent to the ODBC driver in FileMaker?  Since this works without specifying "PK", it appears the problem may be in the WHERE clause.  Make sure the expression matches the same field types.  Your exact statement would be helpful.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Access 2000 / ODBC - FM10AdvSrv
            Ice72
              

            If you could wait untill 2009-06-27, I could upload on my site FP file and JDBC test program,

            so you could test it. I will post the link here.

             

            Is this acceptable for you?

             

            TIA

            • 3. Re: Access 2000 / ODBC - FM10AdvSrv
              TSGal

              Ice72:

               

              I apologize for the late reply.  I'm still playing "catch-up" on this specific "Report a bug" board.

               

              Please post the SQL statement being sent from Access.

               

              TSGal

              FileMaker, Inc. 

              • 4. Re: Access 2000 / ODBC - FM10AdvSrv
                Ice72
                  

                It's difficult to explain, for me.  :(

                 

                There isn't any SQL statament which I write.  The statement is generated from MS Access in reply

                to this actions:

                 

                1) create an empty access file

                2) link a new table

                3) select a FM/DB data source

                4) select the "A" table

                5) access reply showing a list with all A-fields and require to select the primary key field

                6) select the "id" field

                7) access show the "A" table link in the tables list

                8) double click on the "A" table link

                9) BUG!  I obtain a grid with the same number of records in "A"  but with all fields value set to "#####"

                 

                I hope this can be useful.

                • 5. Re: Access 2000 / ODBC - FM10AdvSrv
                  Ice72
                     Missing note: access generate the SQL statement after double click on "A" table link