I'm trying to set up a dsn less odbc link to a table on an 2005 sql server from an access front end. The server uses Sql Server authentication. There are already several tables that are linked to the Access 2007 front end in this fashion. This is an application I just took over and the previous developer is not available. I'm trying to find out how the previous developer was created these dsn-less odbc connections to the backend.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…