TEXT data not appearing

[mfdatsw1]

I have a SQL Server 2000 database with some TEXT type columns. When I created
an Access 2003 project .adp file and opened tables, some TEXT data appears
but some fields appear empty even when I know there's data there. Can someone
tell me why this is happening?

Thanks,
James

 

[Tckg]

your data types might not has been config correctly.

 

[Robert Morley]

Check if the data that's not appearing are the longest ones. There's a
user-controllable cut-off point beyond which any text data won't be
displayed. It's specific to each connection, so the cut-off point in Access
may not be the same as the cut-off point in, say, the SQL Server Enterprise
Manager.

Unfortunately, I don't know how to change this limit in Access (for that
matter, I'd probably have a hell of a time figuring out how to change it in
anything else, either), I just know that the limitation is there, and the
very basics of how it works. Perhaps now that I've mentioned what the
problem is, though, someone else will be able to help you "fix" it.



Good luck,
Rob