How many MEMO fields allowed in a table?
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
|