I am working with a .DBF (MyTest.DBF) file which has plenty of records in it. For a new requirement I had to create a copy of the DBF file for a different application and rename it (MyTest_New.DBF).
When I ran a program and inserted records into MyTest_New.DBF, the same records got inserted into MyTest.DBF too. (And vice-versa) I am not sure how these two files are linked.
The program I ran, creates an MS Access database and creates MyTest_New.DBF as a linked table in it and then inserted records into it.
Is there a different way the DBF files should be created a copy of? Please advise.