Update query

[RichardH]

Is it possible to run an update query which is part of another database?

I have an update query that I would like to run but it's in a different database than the current one. I know I can import queries etc but I just need to run it as it updates tables in that database.

I don't think I'm being clear but if anyone can help me I'd appreciate it

 

[The_Doc_Man]

If you open the DB remotely and trigger execution of a query residing in that DB intended to update tables in that same database, it is POSSIBLE that it will work correctly. Far from a certainty.

The biggest "gotcha" is if there are registry differences (reference differences) between your current machine and that remote machine's original developer's workstation. If so, you run a very good chance of having the query go belly up on you. Depending on the query, anything could happen to your data.

Because of the possibility of problems, I would not attempt this through any other means than directly opening the DB on that remote system and checking references before attempting to invoke anything. If you cannot do this (perhaps because you lack an account on the remote DB or on the remote server), the query wouldn't work by opening it through your local copy of Access, either.

 

[RichardH]

Thanks Doc Man, appreciate it.