Browse by Tags

All Tags » Access 2007 » Engine » Code   (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: , , , , ,
Page view tracker