Update table problem

[BartK]

Hi everyone,
Here is my problem that I am having:

I have 2 db, DB A (older db) DB B (new db) What I have done is updated some functionality of the DB A, what I want to do is have a query that will take all the information in the table of DB B (new db) and put it all into DB A (older db).

I've tried to do the append query but it says that it can't find my table that I want to add the records into. Does anybody have any idea how to accomplish this. I don't care about the records in the older db as long as all the information from the new db is put into the table of the old db.

thanks in advance

 

[bob fitz]

Why not import the table to the old db or link the old db to the table in the new db.

 

[BartK]

Bob,
Thank you for your reply, I have tried to import the table, however when I do that it puts the table down into the "unrelated objects" category, whenever that happens I can't run any of my queries or reports. As for linking them, that isn't an option either being that the guy who wanted me to "tweak" the front end of the db has it on his computer and a network drive that I don't have access to.

I just need to update the old table in the newer db and then e-mail him the finished db so then he can hit the ground running with it. Thank you once again.

 

[soupi]

Did you get it

 

[soupi]

to work? barkt

 

[BartK]

Nope nothing yet, still fighting it.