Borge Hansen
pcs.accessd at gmail.com
Sun Jul 31 07:59:13 CDT 2011
Does anyone know the answer to this? Configuration: *One Machine*: OS: Windows Server 2008 R2 (virtual machine) MS Access 2003 (11.8166.8172) SP3 ODBC Driver: SQL Server Native Client 10.0 : 2009.100.2500.00 SQLNCLI10.DLL 17/06/2011 (Version 10.50.2500) *accesses SQL Server 2008 R2 Express on other machine via TCP* Other Machine: OS: Windows Server 2008 R2 (virtual machine - both machines on same domain) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 6.0 <X86> (Build 6002: Service Pack 2) (VM) The Access 2003 application starts up, re-links all tables to SQL Server Db ok! The offending linked table is a very small table with only three records. All Memo fields on the table are linked defined as text 255 - and as a consequence only the last 255 characters of the field comes across. We have several other installation configurations, where this is NOT a problem - none of which are SQL Server 2008 R2 Express though. We have for example two SQL Server 2008 R2 Web Edition - with expected behaviour on the linked tables. Anyone with answer to this? Would be greatly appreciated! (In the past we have used SQL Server 2005 Express with no problems linking tables with nvarchar(max) as memo fields) So far spent / wasted 1 1/2 day on trouble shooting this. Kind regards, Borge