Split database best practices - what to do with the tables used for lookups

[Pack10]

Quick question on splitting databases. The small tables like the ones used for combo box and listbox and those that act like
temp tables etc...should they also be stored on the back end and linked to....or is it better to keep them with the front end.
Thanks

 

[MajP]

I would still keep in back end. Say you have a new choice you want to add to a lookup. You can go into the back end and add it. If it is stored in the front end, then you now have to send a new front end to all of your users. A lot harder to manage.

 

[Pack10]

Good point. You are correct. Thanks.