Discussion Locked

Accessing SQL Server DB with Access form

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an access form that is linked to a SQL server database. I have one field that is a text field that holds about what a memo (in Access) would hold. I set SQL to have this field as a text or ntext and it truncates it or gives me a "ODBC Failed Call" error. I put it as a variable varchar and I get the same thing. Any help gets all the points!

3 replies

by mbarker734

I don't normally answer a question here without first testing the answer but since I am unsure of exactly what you are attempting this is untested.

I suggest you look into the GetChunk method as it appears to be useable for large fields.

Good luck,

Mark

This discussion is closed to new replies.