Allen Browne wrote:
It might be better to create a more
generic table with fields such as these:
TheVariable Text The name, such as "SalesTaxRate".
TheUser Text Zero-length string if it applies to all
users.
TheValue Text The current value to use for this variable
DataType Long A value that is a member of vbVarType
Descrip Text Description of what this variable is used
Sounds a bit too close to the "One True Lookup Table" design flaw to
me:
http://www.dbazine.com/ofinterest/oi-articles/celko22