Copying and pasting queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to move one query from Database A to a Database B query. I tried
copying and pasting but I am unable to run the query in Database B. I
receive the following error:

The Microsoft Jet database engine cannot find the input table or query
<name>. Make sure it exists and that its name is spelled correctly.

So I go to the design view and sure enough some of the tables? are missing
from the query that was copied from Database A to B. I don't know how to fix
it. Even when I attempt to copy and paste the table from A to B it still
does not work. Any help is most appreciated and please know that I am really
new to Access!

Thanks again in advanced
 
You need the same tables (and queries if you are querying queries) in
database B as you have in database A.

A question what are you trying to acheive?
 
Thanks so much for your response. Can I just copy and paste the missing
tables from Database A to Database B or will I need to copy and paste all
tables from A to B?

I am trying to consolidate our firm's Access/SQL databases into one or two
instead of twenty! They all pull from one particular database but were
created by various people who are no longer with the firm. SO to make things
more streamlined the powers that be want only one or two Access/SQL
databases. Confused?! Thanks again for your responses I GREATLY appreciate
them
 
You will need to copy all the tables/queries referenced in database B, How
similar are the data structures between the different databases?

you can either use cut and paste or

menu File/Get External Data/Import

Make sure you have very good backups before moving stuff around, because in
the long run you are going to merge some of the tables and undoing that type
of thing can be a nightmare.

A tip,

when I have merge several databases together I have created a new field in
each of the tables, this field tells me where the data came from, e.g.
office1.mdb, this allows you to back-track if you need to.
 
Back
Top