Catastrophic failure

Knox777

New Member
Hi,
Whenever I run connecting an excel as odbc database having 5000lines, I get catastrophic failure error. Is there any way to get rid of it?
 

VJR

Well-Known Member
Hi Knox777,

On doing a web search on "excel catastrophic failure error" it shows various links with various reasons like Excel version OR another instance of the file being opened as a background process OR some related to macro workbooks OR due to a control used on an Excel Userform, etc.
So I suggest to do the same and apply the changes/fix relevant to your exact situation.
You can post back what you come up with for anyone having the same issue.
 

Nurul Adibah

New Member
Hi Knox777,

1. Ensure only connection string using excel as database in the whole process of the execution
2. For connecting to Excel as database, the database driver for excel must be installed on the machine
3. Check the valid path for the file and accessible from the machine
4. Check another instance of the file being opened as a background process
5. Put a delay between connect to the database and disconnect from the database
 
Top