Hi i was wondering if any one can advise me, I have two databases and wish to update a an edited table from the second database to the origianl table in the first database. I tried an append query were i could browse for the first database. But this type of query was not suitable as it would add a new set of records to the table in the first database, i only wished to add the edited fields from the second datbase table to the first database table. I have tried a update query, with the following path in the update to field "C:\Documents and Settings\shareen\My Documents\dabatases.mdb\tbl_transactionMaster". But this is not working, am I totally going in the wrong direction or should i just coding this update instead of using a query. Any Ideas!!!!!! please help
