Avatar of patrickmiller
patrickmiller
Flag for United States of America asked on

Access 2013 SQL login error to ODBC SQL database

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

Avatar of undefined
Last Comment
Kelvin Sparks

8/22/2022 - Mon
patrickmiller

ASKER
It also says "login from untrusted domain and cannot be used with Windows Authentication"      I didn't use Windows auth.
Kelvin Sparks

Generally in these sorts of issues, you may have clicked the Use trusted connection option (that implies Windows Authentication).

Personally, I use a dsn-less connection - no dsn to worry about - setup one database and distribute - no connection setup needed on each machine - its ready to go.

You do need VBA to start with to do the connections.


Kelvin
Vitor Montalvão

It's possible to post a screen shot of the ODBC configuration?
And also how are you connecting from Access?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
patrickmiller

ASKER
How do I use VBA to setup the connections?
ASKER CERTIFIED SOLUTION
Kelvin Sparks

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
patrickmiller

ASKER
I have never written a Public Function.    Where would I put this function for it to run?
Kelvin Sparks

In the modules part of the database (you are using the desktop version of Access 2013?)

Kelvin
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Kelvin Sparks

In the toolbar, use the create menu and select New Module


K