Hi Bob,

Why do you need a copy of the data in another table?  Usually having the
same data in more than one place is a bad idea.  Can you use a query to
access the original data instead?  This would eliminate the need for any
automatic updating.

However, if it is really necessary, you can accomplish what you want.  
First, I don't recommend MakeTable queries.  Instead, design a table
with the structure you want, then use Delete and Append queries to clean
it out and reload it.

When you say you want the second table updated automatically, do you
mean periodically, or whenever the first table changes?  If the former,
it can be done with Windows Scheduler and an AutoExec macro that
performs the delete and reload process.

If the latter, there's no good way in Access, as it doesn't support
database level triggers.  You'll need SQL Server for something like
that.

Making the second table read-only is another problem altogether.  That
may require setting up Access security.  There are a lot of books and
articles that cover that topic.

Hope this helps,