<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>19 Nov 2017 12:13:00 Z</lastBuildDate><pubDate>18 Nov 2017 21:19:00 Z</pubDate><description>I am accessing an Excel file as a Data table connecting by OLE DB.&#13;
When the file format is correct it works beautifully however,&#13;
if I (or the user) selects a file that has the incorrect format I get&#13;
that horrible "Fatal Programming Error" window and the program ends.&#13;
&#13;
I am trying to capture the error and send a message to the user that&#13;
he has selected a file with the incorrect format . . .&#13;
I have not found the right alchemy!&#13;
&#13;
When I open the window, and "End of initialization" I refresh the table with:&#13;
TableDisplay(TABLE_QRY_IMP_BOSS, taReExecuteQuery)&#13;
&#13;
I am placing all my error traps right after this command but I still get&#13;
that horrible "Fatal Programming Error" window and the program ends.&#13;
This is an example of the code that I have attempted:&#13;
&#13;
IF HOnError(BOSS$,hErrAll) = True THEN&#13;
Info("There is a problem with the file that you are trying to load." + CR + "Please make sure it has the correct format")&#13;
RETURN&#13;
END&#13;
&#13;
Can someone give me a hand pleezz . . . !&#13;
&#13;
THNX !!&#13;
Joe Maldo</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63369-ole-access-error/read.awp</link><title>OLE DB Access Error</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63369-ole-access-error-63385/read.awp</comments><pubDate>19 Nov 2017 12:13:00 Z</pubDate><description>Hi Jose&#13;
&#13;
look at 'when exception' in the help&#13;
&#13;
Best regards</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63369-ole-access-error-63385/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63369-ole-access-error-63385/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63369-ole-access-error/read.awp">OLE DB Access Error</source><title>Re: OLE DB Access Error</title></item></channel></rss>
