Capture SQL Login Id from Access

[Gti]

Hi all,

I've created an Access 2002 database that has linked tables from MS SQL Server 7.0. Assuming that no security settings were done on the Access mdb file, we know that SQL Server will prompt for the login id and password screen before it allows access to its tables. That is fine with me. The
problem is how do I capture the Login ID of the user so that I can use this value to restrict the user on certain Access objects in the front end.

I welcome any suggestions. Thanks in advance.

Gti

 

[THoey]

This has been discussed here before. If you do a KEYWORD SEARCH, I am sure you will find the answer. Terry M. Hoey