Good afternoon everyone, I am trying to build a very simple search lookup application using access as a front-end and sql server as a back-end. My sql database is already secured on a company Network and part of a large sql server framework. So security is not necessarily a concern as our it area manages that.
That said, the application will consist of four linked tables to the sql database, and four or five forms that search those linked tables. My issue is twofold, I have a static login and password that I had planned on using in a file data connection source via odbc for each table, but I cannot for the life of me get other end users to open the application without it saying it's unable to connect to odbc source. I manually added the password to my odbc connection file and they still can't connect. What am I doing wrong?