Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 SQL Server Text DataType And MS Access Controls

Author  Topic 

nizmaylo
Constraint Violating Yak Guru

258 Posts

Posted - 2001-10-06 : 20:09:54
I need to return text field from SQL Server to MS Access Project.
The only way to READTEXT field in SQL Server is to use TEXTPTR and assign it to varbinary(16).
Question 1. What DataTypeENUM corresponds to varbinary(16)? I tried adVarBinary and adLongVarBinary and both don't seem to work.

Question 2. What kind of control I can use in Access to bind varbinary(16)?

helena
   

- Advertisement -