I have a MAKE TABLE query that updates the information
from one database to another. Now I would like to have
this table updated automatically. I have linked the 2
tables together, but I want the copy to be read only.
What is the best way to handle my problem??
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,
--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
