Copy/Paste from One table to another in two seperate databases

[Ofelia]

I am using Accesss 2007.

I have a table in Database1. I open the table and do a Ctrl-C to copy
everything. Go to Database2 and open the table I want to paste into. I
click on the Select all Button and do a Ctrl-V to paste. I did a paste
append. It works great for the first time. If I go in and try again to
paste more data, it will corrupt the database. Is there a Paste Limit??

I get the error message:

"Cannot open database". It may not be database that your application
recognizes, or the file may be corrupt..

Any help would be appreciated.

 

[Jeff Boyce]

Ofelia

I hope that you have a backup copy (of both databases).

Rather than trying to copy/paste, consider this approach:
* open DB1
* link to the "matching" table in DB2
* create a query that takes records/data from the matching table in DB2
and appends them to the correct table in DB1
* run that query

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP