Question

  • Creator
    Topic
  • #2211650

    Microsoft Access

    Locked

    by valengrey ·

    I recently imported a number of tables from a SQL database into Access 2003. The largest of the tables has was given an icon that is different from the others. It is a blue arrow pointing to a globe. I can open it and view the data. I want to know why it has a different icon than the others and if this is a sign that something is wrong.

All Answers

  • Author
    Replies
    • #3027941

      Clarifications

      by valengrey ·

      In reply to Microsoft Access

      Clarifications

    • #3027935

      usually

      by xnavydk ·

      In reply to Microsoft Access

      the different icon in access denotes an external data source such as an ODBC table such as a sql database table.

      • #3027932

        If that is true…

        by valengrey ·

        In reply to usually

        why then do the other tables that were imported from the same SQL server have the standard table icon?

        • #3027930

          check the properties of the table

          by xnavydk ·

          In reply to If that is true…

          could it be that the table is still linked to the external source?

        • #3027923

          Thanks

          by valengrey ·

          In reply to check the properties of the table

          I believe you are correct. Even though I tried to import the tables, I think that because this one was real-time table it was linked instead of imported. The icon is one that is assigned to linked tables.

        • #3027916

          yes, linked

          by xnavydk ·

          In reply to Thanks

          from an odbc data source. if it was an access table linked to an access back end it would be a different icon.

Viewing 1 reply thread