How to create a DNS less linked server in Access to SQL Server.

  Sometimes you may want to use Access as a front end for SQL Server. When doing this you typically have linked tables to the SQL Server and you have the .mdb on a shared drive for users to access.   Normally you create a DSN and use that for the linked server. All works…

8

Getting "Query is too complex" or "Expression is too complex” when using Access

The scenario, you have an MS Access database and you want to run queries against it. A fairly common thing to want to do J   However, now you are getting the following exception, assuming you are running a .Net application:   System.Data.OleDb.OleDbException: Query is too complex.    at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)    at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams,…

1