keeping "fixed" tables in the front end

[Paul James]

I've been keeping some lookup tables that almost never change in the front
end of my split databases, believing that this would improve performance
since the data doesn't have to travel through the network. However, I've
begun to wonder if this could slow down the queries that consist of tables
from both the front and back ends of the database.

Does joining a back end table with a front end table in a query have an
adverse effect on performance, or is it better to keep the fixed tables in
the front end?

Thanks in advance,

Paul