[AccessD] Lookup Tables Implementation

[Bill Benson]

Arthur,

Cannot give my opinion because I have never done it. Others will give you
theirs no doubt. I do have some questions however.

 1) Is the backend used by multiple users?
2) Supposing you can do (and have done) did as you propose, are you locking
down the BE so users can’t harm the queries?
3) Since I have never tried doing it, I don’t know - so I am asking here -
what does the recordsource look like for a form that bases its data on a
query in the backend? I see no way to link queries (only tables) using
Access’s native import features.

I could see a macro that deletes local queries then copies their
replacements from the BE to the FE being a safeguard against obsolescence.
Not sure I understand the benefits you think are inherent in involving a
back-end to store anything other than tables and indexes.

On Mon, Jan 31, 2022 at 10:25 AM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> We are all agreed on lookup tables v. Value Lists. But now I have another
> question. My habit has been, over the years, to declare the data source in
> the BE not the FE. In cases where a Query is used, that means the query is
> stored in the BE rather than the FE. The advantage is that every form or
> report created "inherits" this information, and automatically creates combo
> boxes etc. for me.
> Opinions about this practice?
>