Page 1 of 1

Copy records from one database to another identical one

PostPosted: Wed Jan 30, 2013 7:04 pm
by chuxtable
Hello,
I am having trouble copying records from one database to another identical one. When I tap "Copy records to" and select the database I want to copy to, I get a message "copying records.." indicating it has worked. However, then I find that the records not only haven't copied to the target database, but have been deleted from the source database. Luckily I backed up before I attempted this, so can retrieve the lost data, howver would like to solve this.
Any ideas?
Regards
Charles

Hi again, I think I just solved my own problem! I discovered that for both the source and destination databases both have to have their security settings for Share Databse set to allow full access. Once I did this, all worked fine.