Well, you seem to be saying "how can your structure accomodate so many different possible types of settings." <g> Naturally, I do make use of a memo field!

USER_ID          Character     10
PROPERTY         Character     30
TYPE             Character      1
USER_CAN_MODIFY  Logical        1
PROPERTY_VALUE   Memo           4

And I have some GetProperty and SetProperty methods, of course. Works well for me. Yours looked fine, I just wondered if you're keeping other settings, then does this mean a different table for each type of setting or had you created this table solely in regards to this question.

>So what does your user_prop table look like?