Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Access   (RSS)
Tuesday, November 24, 2009 9:59 AM

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.
Posted by maspeng | 2 Comments
Filed under: ,
Friday, February 06, 2009 2:49 PM

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:
Posted by maspeng | 0 Comments
Filed under: ,
 
Page view tracker