Wrote a program in Access 2013. 32 bit. Had ODBC connections (System) named MaM connected with sql name 'test' and pw 'testpw'. Accessed the data on the development computer. Windows 7 Pro. I installed the Access 2013 runtime program on a Windows 8.1 system. Setup the 32 bit ODBC connection with the same as above. When I try to use the program when it accesses the data from the SQL server via the ODBC connection it fails with login failure. It refers back to my AD login on the Window 7 computer. I don't know what I did wrong but I really need to fix the issue because I have ten other computers to get this to work on. Right now it works on two Windows8.1 computers. It just stopped on this one. Any ideas?
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft Access