A Query to update a Table

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

Hi,
I have a query in one database which I want to link to a
table in another database. Is it possible? Please advise.
 
You could use a make table query to create a new table, create a Primary Key
on the new table that relates to the primary key of the original table and
link the tables that way.

If you just want to update the original table with the contents of the query
just make the query an append query.
 
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

update query ODBC--call failed 3
update query vs make query 5
query is not updatable;; urgent 1
Update query issue 0
Delete Query: Could not delete from specified tables 0
Counting multiple memberships 1
Updating Make-table query 4
Access update query 2

Back
Top