I've run into a problem with Access 2000 .. i seem to remember someone on here having a similar problem once, but currently the search feature is down, so ..
I run a stored procedure in Access 2000 which is to return records including a large varchar field (couple of thousand characters from memory.
Problem is, it only returns the first 255 or thereabouts characters.
I know Query Analyser does a similar thing, but at least you can set it to return more characters (which I can't find how to do anywhere in Access).
Any help would be greatly appreciated.
Q
I run a stored procedure in Access 2000 which is to return records including a large varchar field (couple of thousand characters from memory.
Problem is, it only returns the first 255 or thereabouts characters.
I know Query Analyser does a similar thing, but at least you can set it to return more characters (which I can't find how to do anywhere in Access).
Any help would be greatly appreciated.
Q