Hi,

I'd like to prevent Excel and Access (well any Microsoft Office
application) from gaining access to a SQL 2000 instance, via an
ODBC connection.

If this we're SQL 2005, I create a logon trigger, and just kill off
unwanted connections.

Can anyone suggest how I can achieve this is SQL 2000?

Thanks,

James.