How can I capture an error as the database opens?

[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?

 

[Keith Wilby]

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

 

[david]

For a bound form, in the form "on error" event.

(david)

 

[Jeff Stroope]

Thanks Keith - I'll try that.
--
Thanks,

Jeff

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