Client/Server Form Restriction (1 Viewer)

[shonamac]

I've been setting up a a client server database and all was going well
until I tested some of the fields I'd created.

They were defined as VARCHAR fields of varying length eg. 300, 500 and 700.
on SQL 7.0 and were being accesed with a form created in Access 2000.

If the number of characters in the data is lower than 255 the field behaves fine. However, if the number of characters exceeds 255 then funny things happen. If you position the cursor in the middle of the data to edit it by adding extra characters, then for every character after 255 is replaced by characters from the beginning of the field. Most strange! It would appear
as if there is a max of 255 field length despite my VARCHAR settings.

Any suggestions would be most gratefully received.

Thanks

 

[Pat Hartman]

Open the linked table in design view and check to see if the long text fields are defined as memo. Access should "see" any text field longer than 255 as a memo data type.

Make sure you are using the latest ODBC driver.