I have set up a client-server database using Access 2000 and SQL7. Fields defined as VARCHAR or CHAR with more than 255 characters are not being brought into Access properly, only 255 characters seem to come across. Is this an Access limitation or can some default be changed? If I use text fields instead, is there a way of limiting how much can be entered into these fields?

When you link to a table that contains text columns that are longer than 255 char, Access should "see" the datatype as memo and handle it properly. If that is not happening, try installing a newer version of the ODBC driver.