I resolved this today. I did have a DISTINCT call in my query which I removed and then was able to see more then 255 chars in Access (thanks RJ)....

Rob,

Thanks, but I don't know how to use Access Reports to write a query. Can Access reports run like a query? I need to run Access queries with parameters and...

rf44,

The field is truncated in Access and is a text field with no char limit. However, the field lives in a linked table from SQL Server and is fine in...

Ok,thanks. I did setup an Access Report and all the chars came through with fields > 256 chars. However, I had to run the report on the linked table and...

Yes, I am aware of the duplicate post and I apologize. It was unintentional and this forum does not allow me to delete my posts. When I created the topic...

Yes, I am aware of the triple post and I apologize. It was unintentional and this forum does not allow me to delete my posts. When I created the topic...

Jeff,

Yes, I was viewing in Query Analyzer. After making that Tools change you suggested, I see that all the chars are actually there, so it's not the DTS job that...