Russell,
I store my settings to a sql type database and I have a table similar to you. I store XML in the memo and do a xmltocurosr() to get the grids settings and cursortoxml() to save the settings. I have not seen any slow downs yet.
>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?