See comments interspersed below....
Well you raise an interesting point and preempted my followup question.
1. When I click SPLIT database, a "be" is created and it has only the TABLE.
The
reports, forms, queries and in the original databse inwhich I went through
the MENUs to get to SPLITdatabase......and I am considering that the
frontend....but it also has the TABLE in it. So are you telling me I have
not actually created a frontend? are you suggesting that I am supposed to
DELETE the TABLE , rather than HIDE it?
When you split the database it moves all of the tables to the back end
(as you state). However the front end still shows the table names with
an arrow next to it, which indicates that it is a linked table. Check
your front end database Tables. Is there an arrow next to a table
name? If so, it is linked to the back end (or some other database).
It is possible, and normal in some cases, to have additional tables in
the front end which are not linked to the back end database. If that
is the case, there will be no arrow next to that table name. Hidden
table or not, that table will not show up in the Linked Table Manager
list, as it's not linked.
2. My follow up question was going to be, is the LINK between the frontend
and the backend functional if I make the frontend's TABLE HIDDEN? (of
course, you are implying that this followup question is irrelevent becuase my
frontend should have NO TABLE......but unless I actively delete it? ? ? ? I
am confused
As a test, I hid a table in the back end. When I went to the Front end
Linked Table Manager that table did show in the list, so the fact of
it's being hidden had no bearing.
Hidden on the back end or not, it's records are available in the Front
end.
Hide the linked table on the front end and it's records are available
if used on forms, reports, and queries as though the table was not
hidden, but you cannot manually open that table and view it's records.
Caveat. Even though you cannot open a hidden table manually it can be
opened using DoCmd.OpenTable "TableName".
What will not show in the Linked Table Manager are any tables on the
front end that are not a linked table, hidden or not hidden.
I suspect that the table you have hidden is not on the back end but on
the front end, and that is why it is not shown by the Linked table
Manager.
Note. To break the link between the back end and front end of a table,
all you need do is delete that table on the front end. It does not
actually delete the table on the back end, just removes the link to
it. You can then either re-link to a different table or import the
table and it's records into the Front end.
I hope this is helps.
