ADMIN ID Logons from Access

[Guest]

Does anyone know how to disable Access from submitting logon attempts to
another database via ODBC? I am getting numerous logons failures to my
database from users accessing it via MS Access and ODBC.

 

[Guest]

Sorry - I meant to say that the logon is for a user by the name of ADMIN.
The user that is logging on to my database has his/her own ID, but this logon
comes through as well.

 

['69 Camaro]

Hi.

From your description, it sounds like "my database" isn't a Microsoft Access
database. If I am mistaken in this assumption and your database _is_ an
Access database file, then you may apply user-level security to your Access
database and remove the "Open/Run database" permissions from the default
Admin user to prevent anyone from opening your database, let alone
connecting to any of the tables.

If I am not mistaken, then your DBMS may be able to log attempts and prevent
users from connecting to your database tables, but Access has no way to
prevent attempts to connect to external tables of another DBMS.

These login attempts are either from a user manually attempting to connect
to your database or from the user running an Access database application
that has been designed by an Access database developer to automatically
connect to your database tables (through table linking, query connection
strings, or through VBA code). Since you have the user's login ID, you need
to ask that person to stop attempting to manually connect to your database
or ask that person who the Access database developer is so that you may get
him to remove the connection to your database, if it is indeed unauthorized.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)