Update External Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure that I was vivid enpugh with my questions... here is a little
more data that might help.....


I have 2 databases (db1 and db2)


I am currently working in db2 and would like to update Table1 from db1 with
data from Table1 in db2 where the field ReqNum in both of the tables are the
same. How would I write a SQL statement to do this?

Thanks for your help,
Chad
 
Why not just make a linked table and then add that link table in your query to
update? Roy
 
Because the servers where I work are very slow and pushing or pulling data
through queries is ALOT more efficient in my case

Chad
 
Because the servers where I work are very slow and pushing or pulling data
through queries is ALOT more efficient in my case
Click to expand...

The IN clause in a query *IS* a linked table - and it's slower than
having an established link, because you need the overhead of setting
up and closing the link each time you run the query. I'd be most
astonished if the IN clause query is faster than the linked table
query!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
If I use linked tables in my database, every query works slow. I would
rather pull all the information that I need to work with when I open up the
database then push it back out when I need to..... this proves to be ALOT
more efficient than running every query (which is a lot) very slowly).

Chad
 
If I use linked tables in my database, every query works slow. I would
rather pull all the information that I need to work with when I open up the
database then push it back out when I need to..... this proves to be ALOT
more efficient than running every query (which is a lot) very slowly).
Click to expand...

Well? Link only the *one* table, and use the linked table only in this
*one* query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top