Browse by Tags

All Tags » Access 2007 » Engine   (RSS)
New Access 2007 Technical Article
20 August 08 10:03 AM
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...
Postedby robcooper | 10 Comments    
Filed under: , ,
Adding multiple attachments from a folder
31 July 08 02:55 PM
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...
Postedby James K. Rivera | 10 Comments    
Filed under: , , , , ,
Access Database Engine Redistributable
10 August 07 02:01 AM
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...
Postedby Zac Woodall | 13 Comments    
Filed under: , ,
New, More Complete Access Overview
27 July 06 12:21 PM
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...
Postedby Erik Rucker | 22 Comments    
Filed under: , , ,
Access 2007 Limits
05 June 06 03:01 PM
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...
Postedby Erik Rucker | 39 Comments    
Filed under: , ,
Access 12's new data engine
13 October 05 05:24 PM
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...
Postedby Erik Rucker | 35 Comments    
Filed under: ,
Page view tracker