Results for:
Engine

• Beginners guide to ODBC

  19 Jun 2009

  The folks @ UtterAccess have produced an useful article titled The Beginner’s guide to ODBC . This is an attempt to equip the developers who want to use Access as a front-end client to any RDBMS (Relational DataBase Management System) backend (ie, SQL Server, DB/2, Oracle, MySQL, PostgreSQL) with the...
• Accessing external data using the IN clause

  27 Mar 2009

  Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword. The most commonly used case is as part of the WHERE clause of a SQL statement to provide...
• New Access 2007 Technical Article

  20 Aug 2008

  Aleksandar Jakšić, who is one of the testers on our team, has written an article that shows you how you can use the Access Database Engine from native applications written in C/C++. The article shows you how to to the Access Database Engine using C or C++, but has a great discussion of the data...
• Adding multiple attachments from a folder

  31 Jul 2008

  Rob Cooper recently made a post, Adding Attachments from a Folder , which shows how to add a single attachment file per row. But what if you wanted to add more than one file? One (highly contrived) scenario would be to add all of the files in a folder to one row, and do so recursively if requested, similar...
• Writing a Count(Distinct) Query in Access

  19 Sep 2007

  We received a question from a reader named Eric week before last about how to write a Count(Distinct) query in Access. In other database applications such as SQL Server, Oracle, and MySQL, the Count(Distinct) aggregate is used to count the number of unique items in a given rowset. For example, consider...
• Access Database Engine Redistributable

  9 Aug 2007

  I was looking for this in search results today and realized that it isn't showing up in the rankings (or maybe it does, but the name isn't very intuitive). The new Access 2007 database engine (which reads and writes .accdb files) is available in redistributable format for those who need to code against...
• New, More Complete Access Overview

  27 Jul 2006

  Way back in October, I posted an overview of Access. We've finally got a complete customer-ready overview for the product that will be going up on the Access site at http://www.microsoft.com/access . If you'd like a printable version of this paper, it is available here . This takes longer than you might...
• Access 2007 Limits

  5 Jun 2006

  This is a quick post to lay out the limits in Access 2007 and make a little clearer how the application works and how it scales. The first table below shows the limits of the database engine itself. Access Database Limits Access database (*.mdb or *.accdb) file size 2 gigabytes, including all objects...
• Access 12's new data engine

  13 Oct 2005

  In the first Access blog post, I noted that Access 12 has a new database engine, but one derived from and very similar to the old Jet engine. There were a bunch of questions & emails about what we did, why, and what it means, and it will take me more than one post to get through everything so please...