Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Open the frontend and relink all the tables. You'll be prompted for the password.
    From then on, users of the frontend will be able to work with the linked tables without having to provide the password. I don't know whether that was your intention.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That's fine Hans, will do nicely.

    Regards and thanks, Darren.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •