let say you have between 35 and 50 checkbox on a form.
would you create 2 tables:
accessTable, field: userid, accessType
accessLookup, field: accessType, description
and add X and/or remove rows to accessTable depending on the user selection
OR
would you create 2 tables:
accessTable, field: userid, haveAccessBit
accessLookup, field: accessBit, description
and sum up the selected check box into haveAccessBit field?
* Edit *
I have to make my choice in the next 2 hours. For now, I would decide with a Heads or Tails.