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!