sql database
2 TopicsLinking a File Table from Microsoft SQL Server to a table within Microsoft Access 2016
I've used the standard method of linking tables from a Microsoft SQL 2012 Database into an Access 2016 Database. Every table linked correctly except for a File Table. Within Access, the linked table displays the File Table's fields but not the records. How can I create a linked table within Access that correctly displays all the contents of the File Table that are within the SQL database? I've tried using updated drivers to create the DSN to allow for connection to the SQL server. There is an integrated test within the DSN creation wizard that displays the connection is successful. I expected the linked table within Access to display the contents of the File Table within the SQL database, but it displays the following images and an ODBC--call failed error message:Solved2.6KViews0likes2CommentsManage SQL creds in Excel
When creating a database connection using excel to a SQL server which has previously been connected to Excel keeps trying to use some old credentials and won't ask me for new ones. Where can I managed these credentials so that I can flush the old creds and input new ones. The old creds never worked so a connection object doesn't exist for this database but these creds seem to be cahced and upon failure to connect the only options I get are retry, cancel or edit but edit doesn't let me do anything with the way I'm authenticating.1.2KViews0likes1Comment