On Thu, 13 Sep 2007 19:29:58 -0500, Michael Gramelspacher wrote:

If so, then Memo fields must be excluded as I have records with two
Memo fields each in excess of 3,000 characters.

On Thu, 13 Sep 2007 13:26:52 -0700, "Jeff Boyce"
wrote:

Access has a limit of (?)2,000 characters per record ... that would be why
multiple text fields at 255 characters each would exceed the limit.

If you'll provide a bit more specific description of the domain you are
working in, the newsgroup readers may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

From Access Help + Specifications + Access Specifications + Tables

Number of characters in a record (excluding Memo and OLE Object
fields) 2,000
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail