Options table or Registry

[lution]

I'm curious about everyone's opinion of creating an Options table to keep track of things like defaults vs. using the system registry.

Example: For a montly report, I'd like to remember the previous end-date the user picked and use previous end-date+1 as the starting date the next time the user runs the report to make it easier on the user.

Thoughts?

thanks
Lution

 

[Uncle Gizmo]

Personally I would favor a local table for each individual user, and a backend table for defaults that applied to the user if they are on a different machine.

Recently I saw another way of doing it, was in this forum but I can't remember the details, however it was a simple function that allowed you to save preferences locally on your machine.

 

[WayneRyan]

Lution,

You could use a local table, disk file, or the registry to save preferences.

I'd opt for the local table. Keeping things within the database is much
simpler. Why make it complicated? The local table approach could even
allow for multiple user preferences, even within the same Windows username.

Wayne