Full Version: update query?
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
sergeanthatch
I have a database that all queries are built from linked tables.
one disadvantage to this is that weekly the information changes (ie add or remove a soldier) and that I can not add or name a key kield to any of the tables. can I have a table update query run ar start up to change a "working copy" of the table?
dannyseager
can you explain what you mean by

QUOTE
and that I can not add or name a key kield to any of the tables
truittb
Also, are the tables linked to the "Working Copy" of the table? Do the weekly updates come from the "Working Copy" or where do they originate?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.