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?
--
Thanks,

Jeff

"Jeff Stroope" <(E-Mail Removed)> wrote in message
news:B9FCC5A8-946C-4E6D-8231-(E-Mail Removed)...
> 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

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

(david)

"Jeff Stroope" <(E-Mail Removed)> wrote in message
news:B9FCC5A8-946C-4E6D-8231-(E-Mail Removed)...
> 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?
> --
> Thanks,
>
> Jeff

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

Jeff


"Keith Wilby" wrote:

> "Jeff Stroope" <(E-Mail Removed)> wrote in message
> news:B9FCC5A8-946C-4E6D-8231-(E-Mail Removed)...
> > 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
>
>