Here's one for the database experts

date posted 17th January 2002 22:36

Linked an ODBC table (from SQL Server) into Access. When previewing the
table, one of the fields shows the word #S_C_M# instead of the data.
When viewing the table using a query, the proper data is shown when only
using a few fields, however, when increasing the number of fields, the
data reverts to #S_C_M#. The field which shows the #S_C_M# changes when
increasing the number of fields in the query.

Any ideas?

Regards

NJ Smith AMIAP
Associate Member of the Institute of Analysts and Programmers

http://www.iap.org.uk
http://redtop.freelancers.net