As per debugging, the cause of the error is not in the MDB or in the file, it is in the application, the value from textile exceeds the variable datatypes where the value is being passed thus returning an error and stopping the restoring. Modified the application and change the datatypes of the variable, tested the changes, as per checking, it is now OK.