I am using the Sconnect and Sattach to update 2 databases as follows Both databases are identical Connect MYdatabase Sconnect Otherdatabase(leaving off entire string-I can Sconnect Sattach Mytable as Othertable projecting temp from othertable then updating Mytable this all works slick as can be but now how do I update in other direction? ??? project temp from Mytable then updating Othertable the Othertable is the sattached Mytable from the sconnected Mydatabase I guess my question is: is the sattached 'Othertable' the actual table or is it like a temp table. This is probably confusing but I want to update Mytable in the sattached database. Tom Hart
