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.)
