Search results

Thanks for that Gary. I shall attempt it tomorrow and will report back the results. Like the pain bit btw - very apt!

Well, to start at the beginning, I collect certain information that another department wants too. We already had a database in place that we use for a number of reasons and the other dept have come along and forced their system onto us. The idea, and the reason why I have full rights to their...

I have full rights to the other database although can't really change anything in there!

Yep, what I'm trying to do sounds mad I know! I work for the NHS and the reason I cant link the tables is because of audit trails and patient confidentiality clauses. Makes things very difficult as I'm also not allowed to have any of the other departments database objects in my database...

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...