Updating excel data with dsn less connection vba
You can create queries against them, report off of them, use them as the record source for Access forms and run Visual Basic for Applications (VBA) code against them.Before going any further, please quickly read: Steer clear of Access Web Applications (AWA) The following article explains How-to ‘Hybridize’ your MS Access Database In Office 365 Azure Database or How-to use an Office 365 Back-End database with your MS Access Desktop Front-End (FE).
Thus far in this tips series on Access and SQL Server, we have created an ODBC Data Source Name (DSN) using the OLEDB driver for connecting to SQL Server 2000, as well as a System DSN to connect to a SQL Server 2005 instance using the new SNAC (SQL Native Client) driver.
In some respects, it is the perfect tool for the casual business user who wants to drill into and share their data. In order to connect to Microsoft SQL Server from Microsoft Access you need to set up at least one Linked Table.