Make a Hidden Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Create tables that have a name starting with USys.

Access treats these as user system tables, so they automatically hide.
 
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.
 
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.
 
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....
 
Back
Top