Thanks for the reply. I've used Paradox Table Add from the menu in Paradox 10 and 11. I've also used two TTables and a TBatchMove component in C++ (which I've done successfully literally hundreds of times.). Here is what that code looks like:
tblCa->TableName=dataModelNames->Strings[i]+".db";, tblU->TableName=uname;, tblCa->Open();, tblU->Open();, tbmU->Execute();, modelUpdated=true;, tblCa->Close();, tblU->Close();, tblU->DeleteTable();
The TBatchMove mode is set to 'append' of course. I do get key violations using this if they exist. Both computers that I've run this on have huge amounts of both ram and disk storage. The BDE is set as follows:
Local Share True, Low Memory Usage Limit 32, Maxbufsize 16384, Maxfilehandles 100, Memsize 42, Minbufsize 4096, MTS Pooling False, Shared Memory Location is blank, Shared Memory Size is 14080, SQLQryMode is blank, Sysflags is 0, Version is 4...