|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 8th, 2004, 04:37 PM
|
|||
|
|||
|
Updating all fields of a record using another db
I have 3 versions of a database. One is the original db and two with updated records. How can I update the records in the original database using the 2 updated databases?
The updates on the 2 databases are on different records. And I need to update all records. I am looking for a way I can do this without explicitly setting each field. The table has 50+ fields. Last edited by Jigsatics : January 8th, 2004 at 06:32 PM.
|
|
#2
January 8th, 2004, 11:26 PM
|
|||
|
|||
|
What I would do is link to the table in the other databases, then create an update query that will take the values from my linked table and update the master table accordingly
S-
|
|
#4
January 9th, 2004, 04:39 PM
|
|||
|
|||
|
If you use the query designer, it is not hard (or time consuming) at all (espically when you think of the alternative, doing it all by hand)
S-
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Updating all fields of a record using another db |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
