I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions.
I would like to disable certain form functionality based on the logged in user. Is there a way to "capture the SQL Server logged in user name" in the Access code? Probably in the form_load/open event.
SQL Server 2005, Access 2007
August 24, 2009 11:14 PM
August 27, 2009 2:08 PM