Saving user preferences

[Chuck]

what would be the recommended method to save user preferences in a front-end
database ? For example, my front-end will eventually have a language
selection option which will allow the users to select the language of choice
for the user interface. I would like their language choice to be saved as
the default.

Should I have a table saved on the front-end (each user will be using their
own front-end) which will contain their preferences. Or should it be a table
on the back-end which contains the preferences for all the users and
determined when a user logs on? Or is there another method to do this?

thanks

 

[Adrian Jansen]

You can also use the Windows registry to do this. Look up the SaveSetting
and GetSetting methods in VBA Help.
Good for just a few user values. But it does mean they are tied to the
machine with those settings. Sometimes its better to put them in a local
table, then you can transport them to another machine just by moving or
linking to that table.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[TC]

FE, BE & Registry are the three choices.

A disadvantage of using the FE, is that when you give them a new FE, this
will clobber their previous settings. That puts the FE out, IMO. This
problem will not happen if you use the BE. Their preferences become, just
some extra "user data".

A disadvantage of using the Registry, is that the VBA functions provided for
that purpose (SaveSettings & GetSettings), will only work in a restricted,
*inappropriate* area of the registry; so you must normally forget those
functions & use the Windows API. That is not a problem, once you have
developed your own wrappers for those APIs (or found some on the internet).

Since it is probably easier to store "per user" values in a table (as
opposed to the Registry), I would recommend you store your refeences in a
suitable table in the BE.

HTH,
TC

 

[Chuck]

Thanks to both. I prefer the registry route so will take a look at the
built-in commands or API's.