ms access and SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

abolfazl.mohiti@gmail.com - 20 Nov 2006 13:16 GMT

I need to use Access and ODBC to insert text into a linked SQLServer
2000 table
Currently I'm using an unbound
form control and an append query("insert into ....").
when i do it,All field trnasport correctly but one filed (data type

:memo) not transport correctly .

memo data type show
???????
in SQL Server

Reply to this Message

Sylvain Lafontaine - 20 Nov 2006 21:29 GMT

Hi, this newsgroup is about ADP, so you should ask your question in a
newsgroup about MDB file and ODBC linked tables, for exemple
m.p.a.externaldata or m.p.a.odbclientsvr .

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

>I need to use Access and ODBC to insert text into a linked SQLServer
> 2000 table
[quoted text clipped - 5 lines]
> ???????
> in SQL Server

Reply to this Message

aaron.kempf@gmail.com - 20 Nov 2006 21:34 GMT

yeah you should be using ADP and not MDB.

-Aaron

> I need to use Access and ODBC to insert text into a linked SQLServer
> 2000 table
[quoted text clipped - 5 lines]
> ???????
> in SQL Server

Reply to this Message

CyberDwarf - 21 Nov 2006 18:39 GMT

For MEMO, try NTEXT, or NVARCHAR types

Reply to this Message

aaron.kempf@gmail.com - 21 Nov 2006 19:18 GMT

oh.. text or varchar

why use unicode if you don't need to?

performance / IO

-Aaron

> For MEMO, try NTEXT, or NVARCHAR types

Reply to this Message