Hello
I have a Access database,with copies in different folders,but whenver there are some changes,if i try to copy the particular table and paste it to replace the existing one in my local drive, (by pasting the Structure and data or Appending data) i get a message called delete existing relationships.
Is there anyway to do it without deleting the relationships.
Suggest me as this would help me keep the database on my local folder updated and not disturbing the main database while we make changes to the table data or other forms or reports.
Thanks

instead of copying and pasting the tables, place a link to them from the copy to the main datbaase.

I tried placing a link to the table in the local drive and then tested it with some changes to the main database in the enterprise space.
What happens is there is another table with the same name (eg Organization1) created with the link to it in the local drive.So why is that, isnt that making it duplicate.So whenver i make changes would it create such tables like 1,2,3 etc.
Thanks