Hello,
I've made a split database (current size 157,234 KB) and it was working well, until recently it begun to crash during data import. The error it gives "Unrecognized database format...". I have several procedures in the main module that first import data to temp tables and later insert into database tables. The import procedure doesn't always fails but it's difficult to tell what causes the issue. I'm able to recover the database from a backup and re-import the data from the same text files without an issue. I'm exploring the possibility of moving the tables to SQL server, if this will help. I'm seeking your advice how to troubleshoot/solve this issue.
Thanks,
Mila
I've made a split database (current size 157,234 KB) and it was working well, until recently it begun to crash during data import. The error it gives "Unrecognized database format...". I have several procedures in the main module that first import data to temp tables and later insert into database tables. The import procedure doesn't always fails but it's difficult to tell what causes the issue. I'm able to recover the database from a backup and re-import the data from the same text files without an issue. I'm exploring the possibility of moving the tables to SQL server, if this will help. I'm seeking your advice how to troubleshoot/solve this issue.
Thanks,
Mila