How can I capture an error as the database opens?

  • Thread starter Thread starter Jeff Stroope
  • Start date Start date
J

Jeff Stroope

Hello,

I have an Access 2003 database that has a linked SQL Server table. Some of
the database users don't have select permissions on the SQL Server table so
the database throws error #3146 ODBC--call failed when the database opens.
I'd like to just handle that error to eliminate the user getting the error
message. Where do I put the code to catch that error?
 
Jeff Stroope said:
Hello,

I have an Access 2003 database that has a linked SQL Server table. Some
of
the database users don't have select permissions on the SQL Server table
so
the database throws error #3146 ODBC--call failed when the database opens.
I'd like to just handle that error to eliminate the user getting the error
message. Where do I put the code to catch that error?

I assume you have a form set to open in the start-up options. Have you
tried trapping the error in the form's Open event? You can cancel the Open
event if the error is trapped.

Keith.
www.keithwilby.com
 
Thanks Keith - I'll try that.
--
Thanks,

Jeff


Keith Wilby said:
I assume you have a form set to open in the start-up options. Have you
tried trapping the error in the form's Open event? You can cancel the Open
event if the error is trapped.

Keith.
www.keithwilby.com
 
Back
Top