Question: What is the best way to copy my Paradox tables?
Answer:
What I recommend for our clients is to make sure no one is using the tables and then copy the entire folder. To make sure no-one is using the tables, check for .LCK lock files. If they exist, try deleting them. If you can delete them, then they were left over from an abandoned BDE session. Next, rename the folder to lock out users for the duration of the copy. Copy the folder, then rename the folder back.
To copy live tables, I suggest you write an application in Paradox, Delphi, etc. that uses the BDE copy table code. It's safe, effective, and you can build in error checking.