Hidden attribute

  • Thread starter Thread starter mark r
  • Start date Start date
M

mark r

SO I thought it would be a good idea that when I give my boss his
front end and backend, that I hide the TABLE sitting in his front end;
and I don't even let him open up the backend.

this way he can't mess up the tables in anyway
just select the TABLE
hit properties
click HIDDEN ATTRIBUTES
end the TABLE is invisible

BUT now my headache started
Linked Table manager doesn't see TABLE either
I can't select the TABLE to refresh the link

Also, I can't unhide TABLE
cuz it is hidden, I can't choose properties


????????????????
quandry
enigma
?????????
what's REALLY going on here - what have I done?
 
SO I thought it would be a good idea that when I give my boss his
front end and backend, that I hide the TABLE sitting in his front end;
and I don't even let him open up the backend.

this way he can't mess up the tables in anyway
just select the TABLE
hit properties
click HIDDEN ATTRIBUTES
end the TABLE is invisible

BUT now my headache started
Linked Table manager doesn't see TABLE either
I can't select the TABLE to refresh the link

Also, I can't unhide TABLE
cuz it is hidden, I can't choose properties

????????????????
quandry
enigma
?????????
what's REALLY going on here - what have I done?
Click to expand...

Gina told you how to unhide the table, but if, as you state, the table
is sitting in his front end, there is no link to refresh.
 
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?

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
 
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?
Click to expand...

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
Click to expand...

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.
 
I know you are trying to help, but you have really confused the issue. You
went on and on about hiding tables in the backend. If yu read my two
questions, they refer to hiding tables in the front end. could you refocus
and get to the point in a straighter path please? stick to my questions and
don't wander off about backend TABLES being hidden. In my example, the is
only 1 TABLE and only that table is split.
 
Back
Top