Search results

  1. J

    How to solve Access limitation of a memo field mapped to nvarchar(max) field in SQL

    SOLVED! If you create the following table in SQL Server 2008 and link it to Ms Access, the only way to copy-paste a very large amount of text in Access into the memo field is by using code. Opening the linked table in view mode and copy-pasting the text manually causes the error “ODBC call...
  2. J

    How to solve Access limitation of a memo field mapped to nvarchar(max) field in SQL

    Thank you for replying. We had a similar problem but resolved it with a third party text control. There must be a work around to mapping a memo field from Access to SQL server.
  3. J

    How to solve Access limitation of a memo field mapped to nvarchar(max) field in SQL

    Hello, Our company is migrating a Microsoft Access 2010 backend database to a SQL Server 2008 database. One of the memo fields in the Access backend can store up to 150 Kb of Unicode data. To store this data in SQL server, we found that we can use the following data types: ntext =...
Back
Top Bottom