Hi
Wonder if anyone can help me? Is there any way of using an update query to update a table that's not within the database the query runs from? We're already using an append query to send the data across, but it is amended and updated regularly wich of course the append wont reflect. I'm not allowed to link the tables either!
Any suggestions?
Wonder if anyone can help me? Is there any way of using an update query to update a table that's not within the database the query runs from? We're already using an append query to send the data across, but it is amended and updated regularly wich of course the append wont reflect. I'm not allowed to link the tables either!
Any suggestions?