Make a Hidden Table

A

Andy

I need to run a number of queries via a macro for an end product. Rather than
have loads (circa 30) tables visible to the front-end user, I was wanting to
output the make table queries as a hidden table so that the user did not see
everything.

Anyway to do this or other suggestions?
 
A

Allen Browne

Create tables that have a name starting with USys.

Access treats these as user system tables, so they automatically hide.
 
J

Jerry Whittle

Name all the tables with MSys in the first four characters. Then as long as
System Objects is unchecked on the Tools, Options, View tab menu, the table
will not be seen. For good measure uncheck Hidden Objects also.
 
R

Rick B

Why make a table? Pretty much anything you can do with a table can also be
done with a query. Just use the query as your record source or export the
data from the query. Most likely no need to make a table.
 
A

Andy

Have tried putting the first 4 digits on the make table name as 'MSys' with
the relevant checks turned off, but the table is still visible as a normal
table....
 
A

Andy

Usys seems to work, but MSys doesn't. Problem solved, but could MS not allow
an option of how you want a table to be outputted to allow the front-end to
be tidy?

Thanks
 
A

Allen Browne

Andy, there are other switches and flags that can be set.

But I can't recommend that. A few years back there were stories that Access
misunderstood these as flags that the table should be deleted next time you
compact the database - not the kind of thing you want to chance.
 
Top