General discussion

Locked

Accessing SQL Server DB with Access form

By Dutchman ·
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!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Accessing SQL Server DB with Access form

by mbarker734 In reply to Accessing SQL Server DB w ...

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

Collapse -

Accessing SQL Server DB with Access form

by Dutchman In reply to Accessing SQL Server DB w ...

Poster rated this answer

Collapse -

Accessing SQL Server DB with Access form

by Dutchman In reply to Accessing SQL Server DB w ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums