Is it possible to link a table to a query that is not updateable?

  • Thread starter Thread starter Tom
  • Start date Start date
Tom said:
If so, how?
Click to expand...

Only tables can be linked, not queries. Use the Linked Table Manager, File |
Get External Data | Link Tables.
 
A query accesses data from tables. A query can be read only, write only (as
when adding or updating a record), or read/write.
 
A query returns a result set which is itself a table, but not a base table.
A table, or another query, can be joined (which is what you mean by 'linked'
I suspect) to a query just as if it was a base table, but where the result
set of a query is not updatable the resulting query will not be updateable.

If you can give more detail of what you want to do we might be able to be
more specific in our advice.

Ken Sheridan
Stafford, England
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to link memo fields? 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
After re-linking tables to a new server, all queries don't see upd 1
Linked Excel Table, Update Table 1
Update a table from a query 7
Linked Excel spreadsheet to be used as table 3
Update Query from Access 2003 Linked Table 1
Access Dcount (multiple criteria) 3

Back
Top