[AccessD] [dba-SQLServer]Access ADP Error

I would try changing the Data Type to Text and setting the limit at like
5000 characters (Access Text datatype <> SQL Text datatype)

I remember a long time ago having to do that with an Access 97 FE SQL 7 BE
so it may not be the same issue, but worth a shot.

Chris Mackin
Denver Database Consulting, LLC
www.denverdb.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Myke Myers
Sent: Friday, April 11, 2003 10:45 AM
To: accessd at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
Subject: [AccessD] [dba-SQLServer]Access ADP Error


I upsized an application from an Access FE / BE to an Access ADP FE / Sql
Server 2000 BE.

A memo field for Notes became a 'ntext' field in Sql Server.

A user is getting a message 'The text is too long to be edited' when she
clicks into the Notes field in several records -- records with a lot of data
stored in the Notes field. My understanding is that the Sql Server 'ntext'
field is limited only by the storage of the server, so I'm guessing that the
problem is with the Access Adp FE.

Does an Access Adp textbox have a limit on the amount of data it can hold?

All suggestions welcome.

TIA,
Myke