469,140 Members | 1,205 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,140 developers. It's quick & easy.

access97, sql2005 memo field in a linked table shows as a text field

I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'

when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today

if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field

I don't think anything was changed on sql2005 or access97 since
linkage of the first table produce the correct field type

does anyone know what is required to get access97 to link a memo
field ?

Aug 21 '07 #1
2 3084
On Aug 21, 12:59 pm, Roger <lesperan...@natpro.comwrote:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'

when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today

if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field

I don't think anything was changed on sql2005 or access97 since
linkage of the first table produce the correct field type

does anyone know what is required to get access97 to link a memo
field ?
If I change the sql table field from 'ntext' to 'text' and relink, the
access field is now 'memo', but when I display the table contents I
see "#Name?" in all fields

yet if I open a recordset to the table and debug.print all the data in
all rows, it looks ok

note, the sql table has a 'timestamp' field, which I thought fixes the
#Name? problem

recreating the ODBC data source doesn't help
Aug 21 '07 #2
On Aug 21, 2:44 pm, Roger <lesperan...@natpro.comwrote:
On Aug 21, 12:59 pm, Roger <lesperan...@natpro.comwrote:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'
when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field
I don't think anything was changed on sql2005 or access97 since
linkage of the first table produce the correct field type
does anyone know what is required to get access97 to link a memo
field ?

If I change the sql table field from 'ntext' to 'text' and relink, the
access field is now 'memo', but when I display the table contents I
see "#Name?" in all fields

yet if I open a recordset to the table and debug.print all the data in
all rows, it looks ok

note, the sql table has a 'timestamp' field, which I thought fixes the
#Name? problem

recreating the ODBC data source doesn't help
the sql table actually has 3 'text' fields, and if I delete 2 of them,
the linked table shows it as a memo field, and the table view
correctly shows the data instead of #Name?

note, using one 'ntext' field still fails to create a memo field

so unless someone can provide more insight, I'll create three tables,
where the last 2 will have just a 'text' field, and I'll modify the
form(s)
Aug 21 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Helgardh | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.