Where would I arrange things fe/be-wise?

[Access9001]

Is this accurate in general:

Backend:
Tables only

Frontend:
Linktables, queries, forms, macros, etc.

So if I have another frontend and I need to, say, edit information in the backend tables, do I just link, again, straight into that backend? Can someone explain the logic of always using queries to access backend tables to hide the fact the fe/be split occurred?

 

[Dairy Farmer]

Correct setup as you explained.

Can someone explain the logic of always using queries to access backend tables to hide the fact the fe/be split occurred?

Whether the tables are linked or not makes no difference to Access. As far as Access is concerned they are in the same database.