<div>
If you have a previous (or backup) copy of the Access file wherein the connected table still resides, you should be be able recover the table by 'copying' the table from the old file to the current one.using the 'Externa Data' tab in the ribbon.<br><br>
</div>


<div>
Natchiket,<br>Thanks for your suggestion, however, let me explain that while in SSMS I still have full access to the database.<br><br>The problem is that I am trying to create a link using the following string:<br>strConnect = "ODBC;Driver={ODBC Driver 17 for SQL Server};Server=SQLSERVERLITE;UID=MyUserName;PWD=MyPassword;Database=MyDBname;"<br><br>This string works fine for all the other databases on my SQL Server, however, in this case I get the message shown above. &nbsp;I believe the database may not be setup to use the same username and password as I'm passing it in this string, and don't know how or where to add it.<br><br><strong>I"m not sure if this is significant, but when I go Security--Users--.then click on my username.. then properties.. the database which works with my credentials has a section titled User Name Login. &nbsp;In the case of the database that does not work with my credentials, then entire section is missing. &nbsp;No login name exists.</strong>
</div>


<div>
If you can acces the table directly via SSMS using those credentials then you should be able to connect to it from Access<br>the only thing I can suggest is try using<br>"DRIVER=SQL Server" , which is what I use rather than "Driver={ODBC Driver 17 for SQL Server}"
</div>


<div>
When I log into SQL server I use my admin login. &nbsp;I can then access the database and table.<br>I never use the credentials which I use in the connection string.<br><br>I have several other databases in this instance of the sqlserver. &nbsp;All work when I use the same string but only change the database name with the same username&lt;&lt;password combo
</div>


<div>
So maybe on that database in SSMS expand the Security node and add the account to the Users node ?
</div>


<div>
Probably the user you user does not has permissions to "access" the database...make a quick test using the sa account on the Connection String&nbsp;
</div>


<div>
Andrei.. thanks for the detail...<br>When I follow your example and view the "Users mapped to this logon" screen the databases of concern are NOT checked. &nbsp;When I check them I get the message:<br><br>An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)<br>------------------------------<br>User, group, or role 'MyUserName' already exists in the current database. (Microsoft SQL Server, Error: 15023)<br><br>What doe this mean???<br><br>John... I changed the credentials to the sa account and it still gave me the same error.
</div>


Founder and CEO

pcalabria

<div>
<div class="content wysiwyg-content fr-view">
<div><div class="content wysiwyg-content fr-view"><p>I am trying to connect to a linked MS SQL Server table from MS Access.<br>Previously, the table was already linked and all worked fine.</p><p>I deleted the link however, and am now trying to reconnect.<br>I'm getting this error:<br><br>Connection Failed:<br>SQLState 08004<br>SQL Server Error: 4060</p><p>Server rejected the connection; Access to the selected database is denied<br>Connection failed:<br>QLState 28000</p><p>SQL Server Error: `8456</p><p>&lt;ODBC Driver 17 for SQL Server<br>Login failed for user 'MyUserName'</p><p><br></p><p>The sql string includes the user name and the password I believe the database uses.<br>I suspect the password in the sql string is different that the password I used when I created the original string</p><p><br></p><p>Can someone tell me how I can check/ and or update/ the password for this database from inside SQL Server 2017?</p><p><br></p><p>The user name does appear in the Security--users section of the SQL instance running.</p><p>I have tried adding a new user name and password..in the main security section ... but that combination failed also.<br>Thank you</p></div></div>
</div>
</div>



I am trying to connect to a linked MS SQL Server table from MS Access.
Previously, the table was already linked and all worked fine.
I deleted the link however, and am now trying to reconnect.
I'm getting this error:
Connection Failed:
SQLState 08004
SQL Server Error: 4060
Server rejected the connection; Access to the selected database is denied
Connection failed:
QLState 28000
SQL Server Error: `8456
<ODBC Driver 17 for SQL Server
Login failed for user 'MyUserName'
The sql string includes the user name and the password I believe the database uses.
I suspect the password in the sql string is different that the password I used when I created the original string
Can someone tell me how I can check/ and or update/ the password for this database from inside SQL Server 2017?
The user name does appear in the Security--users section of the SQL instance running.
I have tried adding a new user name and password..in the main security section ... but that combination failed also.
Thank you

Need help changing password for an SQL Server table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.