Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TerryDASNY
- Order by date
-
Trouble linking a SQL Server varchar field to memo field
Thanks again lupins46. I did get your suggestion to work once I changed the data type of the field in the view to a type of ntext(CAST(Comments as ntext)). Initially I was changing the Comments field data type in the table that was the data source for the view I was linking to MS Access. Once...- TerryDASNY
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Trouble linking a SQL Server varchar field to memo field
Thanks for your suggestions lupins46. I changed the SQL Server data type for that field to text ntext and nchar relinked the view each time and all of those SQL Server data types converted to Access data type of text (255). I still wind up with my truncated comment field. Bummer.- TerryDASNY
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Trouble linking a SQL Server varchar field to memo field
Hello, I am linking a SQL Server view that has a varchar (500) field containing a comment. When I link this view to MS Access, the varchar field converts to a text (255) and truncates the data. I tried modifing the data type in the linked view in Access to a memo data type, but Access will...- TerryDASNY
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
