September 12, 2012 at 6:59 am
My Access 2003 (or 2007) has linked tables to SQL Server 2008 (I'm using SQL Native Client 10). Forms, reports and queries are, naturally, local. Problem: all data nvarchar(max) fields are truncated - in Access the record is chopped - ~ 255 from the end of the record. Can it be fixed? And if yes then HOW?
September 12, 2012 at 1:11 pm
What type are the Access datafields? Memo?
September 12, 2012 at 2:18 pm
Yes - memo
September 13, 2012 at 3:23 am
I don't have the time to test it properly.
Do you have the problem in a blank access 2010 database? As 2003/2007 is out of active support. Office life cycle
September 13, 2012 at 7:56 am
No 2010. Why no active support for 2003-2007 (by Microsoft?)
Actually I found the solution - changed (n)varchar(max) to text, and this one Access handles as memo.
Thanks
September 13, 2012 at 10:48 am
valeryk2000 (9/13/2012)
No 2010. Why no active support for 2003-2007 (by Microsoft?)Actually I found the solution - changed (n)varchar(max) to text, and this one Access handles as memo.
Thanks
That may work short term but in the long run that is not going to survive. The text datatype has been deprecated and will be removed in the future.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 13, 2012 at 1:51 pm
That may work short term but in the long run that is not going to survive. The text datatype has been deprecated and will be removed in the future.
It will happen to versions later that 2008.
September 13, 2012 at 2:02 pm
valeryk2000 (9/13/2012)
That may work short term but in the long run that is not going to survive. The text datatype has been deprecated and will be removed in the future.
It will happen to versions later that 2008.
The text datatype is still available even in sql 2012 but it will go away at some point in the future.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply