Question

Locked

Microsoft Access

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.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

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.

Collapse -

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?

Collapse -

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?

Collapse -

Thanks

by valengrey In reply to check the properties of t ...

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.

Collapse -

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.

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums