From: someone@microsoft.com   
      
   The error is not thrown that's why you are not seeing it there it is   
   displayed by the adodc   
      
   put this in the adodc_error event thandler   
      
   fCancelDisplay = True   
      
   and it will stop the error being displayed   
      
   "Steve Gerrard"  wrote in message   
   news:fsOdnbnDxd6EsF7eRVn-vg@comcast.com...   
   >   
   > "Raoul Watson"  wrote in message   
   > news:wOEwf.1807$JT3.1534@trndny06...   
   >>I have a form with an AdoDc control associated to a datagrid.   
   >> The AdoDC uses a "ConnectionString" such as   
   >> "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data   
   >> Source=..."   
   >>   
   >> this is where the problem begins. The data source will not be known until   
   >> the user selects the database.   
   >>   
   >> What is really weird is that if the source is not placed during design   
   >> time,   
   >> during run time the form upon loading will generate an error ("Failed to   
   >> authenticate"). This error seems to be untrappable since it doesn't occur   
   >> in   
   >> the Form Load or Activate event (I have tried to catch it there).   
   >>   
   >> Of course once the error is ignored and the datasource is set in the form   
   >> load, everything works OK.   
   >>   
   >   
   >   
   > You should be able to start the app without an error if the connection   
   > string property of the ADODC control is completely blank. Then set the   
   > entire connection string in code, including the part about "Provider="   
   > etc.   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)