Question Locked

Microsoft Access

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

6 replies

by xnavydk

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

by valengrey

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

by xnavydk

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

by valengrey

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.

by xnavydk

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

This discussion is closed to new replies.