How To Resolve The 3151 ODBC Connection Failed Access Error In MS Access?

Asked By Galie Stratus 0 points N/A Posted on - 11/02/2020

I created a new ODBC connection in MS Access. I did that successfully. When I tried to update the DB, I encountered an error. How to resolve the 3151 ODBC connection failed access error in MS Access?

• Status: Open
• Question Views: 194
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware
• Question Tags: Windows

Answered By VillarosaRoberts 0 points N/A #344252

How To Resolve The 3151 ODBC Connection Failed Access Error In MS Access?

Follow the steps given below to resolve the 3151 ODBC connection failed access error in MS Access –

a. Open Access.
b. Open the File menu.
c. Click on the Get external data.
d. Click on the Link tables options.
e. Select your ODBC database.
f. Click on the Machine Data Source option.
g. New option.
h. Select the System Data Source – > Next.
i. Click on the SQL Server option -> Next -> Finish.
j. Name your ODBC connection and SQL Server.
k. Click on next.
l. Tick the “With SQL Server authentication using a login id and password entered by the user” option -> Next.
m. Choose the appropriate database -> Next -> Finish.
n. Click OK until the SQL Server login page comes.
o. Enter the credentials of the SQL server database
p. Click OK.

About VillarosaRoberts

Questions
1

Answers
24

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 11/02/2020
• Question Category: Hardware