No, this is a technical limitation. But there are workflow alternatives. Why do you need all 40,000 records offline at once?
You could split your data across multiple surveys based on category.
You can use a custom URL from an external source (field maps) to query and pull down records as required using url parameters.
Or apply a filter so that only the most relevant records are pulled down.
e.g. you have 40,000 assets you need to maintain. You could split them into 20 sections and do one section at a time based on an active field.