Linked Table: replicated versus local?

  • Thread starter Thread starter Farrel Buchinsky
  • Start date Start date
F

Farrel Buchinsky

About 4 months ago our database manager set up a Microsoft
Access front end on my computer that could interact with a table in a Sybase
backend database. If I open the Design Master / Tables section, I see the
linked table and it has a very fancy icon (arrow into a globe with a yellow
ball to the right of the globe with two circular arrows within), and the
following description appears under type, "Table: Linked ODBC (Replicated)"
When I open the table I get an error message because the structure of the
backend table changed about 3 months ago.

To overcome the problem I simply went through the process of linking the
table again (File / Get external Data / Link Tables). Everything works now.
However I have noticed two differences and I do not know the implications
thereof. The icon is now without the yellow ball and the table type
description is "Table: Linked ODBC (Local)."

What on earth is the difference between these two setups and how did it
occur?
 
Never worked with Sybase.

You should ask your database expert on site this question.

FYI
If the server table structure changes, then you are supposed to delete and
re-create the link.
 
Back
Top