#deleted returned in every field from linked table

[Big Ern]

All -

I'm having a strange thing happening here. I'm trying to link a table from a
Sybase ASE server through ODBC and when I try to open the table, all I see is
#deleted in every column in the database. I've never ran into this before so
I"m not sure what is happening here....I'm running Sybase ASE 12.5.4. I do
have a primary key on the table and it is a numeric data type.

 

[Lou]

All -

I'm having a strange thing happening here. I'm trying to link a table from a
Sybase ASE server through ODBC and when I try to open the table, all I see is
#deleted in every column in the database. I've never ran into this beforeso
I"m not sure what is happening here....I'm running Sybase ASE 12.5.4. I do
have a primary key on the table and it is a numeric data type.

Have you altered the table definition in Sybase? Just relink the
table and the problem will go away. Hint: Use the file menu
GetExternalData, Link tables.

 

[Big Ern]

The table structures have not been altered. I've tried re-linking the tables
several times, but it does not change anything.

 

[John W. Vinson]

The table structures have not been altered. I've tried re-linking the tables
several times, but it does not change anything.

If you've used the Link Table Manger that may not be enough. Try deleting the
tables (the links, that is) from the Access database and using File... Get
External Data... Link to connect afresh.

It may even be necessary to delete the ODBC connection and recreate it.