Some Fields from a linkes SQL Server DB display#S_C_H#

A

Adam Simpson

We have an Access 97 front end database and a SQL Server 2000 backend with
linked tables using ODBC connection. One table that tha many text fields
frequently displays #S_C_H# . It does not appear to happen in any other
fields and occures when looking at the table or the data in a form. Both
these fields and many others are varchar fields in SQL Server. A simple
refresh of the data usually gets rid of it and displays the real data, but
it is very anoying.

Does anyone know how to stop this happening or why it happens.

Thank you for any response

Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot link to SQL server 17
Conneting to SQL server, Need advice 4
linking to SQL Server db table 6
#DELETE in all fields after linking to SQL Server table 1
problem when linking an Access DB to SQL Server with bigint dataty 2
SQL Custom Data Types Not Visible In Access Linked Tables 1
Linked tables to SQL 1
Append data to linked SQL Server 2008 table 0

Top