A few days ago, Eric Rucker posted about the various limits in Access 2007 in this post, including my favorites:

Number of characters in a table name 64
Number of characters in a field name 64
Number of characters in a text field 255
Number of characters in a validation rule 2048
Number of characters in a validation message 2048
Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property is set to Yes. 4000
Number of characters in a field property setting 255
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of characters in a cell in the query design grid 1024
Number of characters in a parameter in a parameterized query 255
Number of characters in a SQL statement Approx 64,000
Number of characters in a label 2048
Number of characters in a text box 65535
Number of characters in a SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control. 32750
Number of characters in a condition 255
Number of characters in a comment 255
Number of characters in an Action Argument 255

As to why these are my favorites?

Well, because each use of "Number of characters" actually ought to read "Number of UTF-16 code units" since e.g. the string

ểểểểểểểểểểểểểểểểểểểểểể

is actually 66 of those types of "characters" long even though any user would reasonably count it up as being of length 22.

Unfiortunately, Access and Jet don't consider that object and one with this name:

ểểểểểểểểểểểểểểểểểểểểểể

(the first is in normalization form D, the second in form C).

Anyone want to calculate the number of possible unique object names one can create with just this one character? :-)

 

This post brought to you by ể (U+1ec3, a.k.a. LATIN SMALL LETTER E WITH CIRCUMFLEX AND HOOK ABOVE)