Browse by Tags
All Tags »
Engine (RSS)
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
Read More...
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
Read More...
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
Read More...
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 to Rob's example.
What follows is some VBA code to do this, which borrows a bit from Rob's post and a bit from one of my earlier posts. However, I should point out this (again, highly contrived scenario) is meant only as an example and not something I would recommend doing, because if you are adding more than just a few files you can (ok, WILL) bloat your database very quickly, and in doing so can negatively impact performance and potentially hit the two gigabyte file size limit very quickly (see Access 2007 Specifications for details on database file size and object limitations).
Read More...
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
Read More...
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
Read More...
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
Read More...
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)
Read More...
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
Read More...
