Hi, I have a back end DB which is password protected (recently had to) and to be honest I am not sophistcated with security, it’s just a simple password protected. However my front end, where users run reports is now not picking up details from a query used to populate a form on t e front end. When I move the password on the back end all works fine so by deduction the issue is the password. How can I keep the password and get around this issue?
I have a default value to pick up a user name in a combo on the front end…
=DLookUp(“[individual ID]”,”tblIndividuals”,”[memoID]= fOSUserName ()”)
The combo row source is: SELECT [tblIndividuals].[forename] & ” ” & [tblIndividuals].[surname] AS CC, [tblIndividuals].[Individual id], [tblIndividuals].[surname], [tblIndividuals].[Forename] FROM (tblTeamManagers INNER JOIN tblTeams ON [tblTeamManagers].[Team Manager ID]=[tblTeams].[Team Manager]) INNER JOIN tblIndividuals ON [tblTeams].[Team ID]=[tblIndividuals].[Team] ORDER BY [tblIndividuals].[forename] & ” ” & [tblIndividuals].[surname];
The password is clearly denying the query access to the underlying tables…
Many thanks, Darren.
