|
Home > Archive > MS Access project with SQL Server > February 2006 > TEXT data not appearing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
TEXT data not appearing
|
|
| mfdatsw1 2005-12-13, 1:24 pm |
| 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
| |
|
| your data types might not has been config correctly.
"mfdatsw1" < mfdatsw1@discussions
.microsoft.com> wrote in message
news:3857D685-584A-40A9-AB11- B19938140C05@microso
ft.com...
>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
| |
| Robert Morley 2006-02-09, 11:24 am |
| 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
"mfdatsw1" < mfdatsw1@discussions
.microsoft.com> wrote in message
news:3857D685-584A-40A9-AB11- B19938140C05@microso
ft.com...
>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
|
|
|
|
|