ms access and SQL Server

[abolfazl.mohiti]

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

 

[Sylvain Lafontaine]

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 .

 

[aaron.kempf]

yeah you should be using ADP and not MDB.

-Aaron

 

[CyberDwarf]

For MEMO, try NTEXT, or NVARCHAR types

 

[aaron.kempf]

oh.. text or varchar

why use unicode if you don't need to?

performance / IO

-Aaron