Not Exactly Technical but worth checking out

If you are interested in keeping on top of MS Access and its road ahead, you might like to read this blog

http://blogs.msdn.com/access/

 I was looking for information on Access 2007 service packs, performance improvement, etc., and turned to the semi-official Microsoft Developer blog.  There is a posting from Bill Gates on the impetus to move Access functionality to the web with Sharepoint.  Looks like the authors post every week or so.

Die database, die! Five reasons why Access has not disappeared.

I just started a data management assessment for a new client with my colleague Emily Graham. The organization uses a dizzying array of contact and process management tools from rolodex to high end commercial nonprofit CRM software. A custom-developed Microsoft Access database sits squarely in the middle.  

Microsoft Access error: "The database has been placed in a state by user..."

This error can suddenly arise in a Microsoft Access database that has been in day to day use without problems for some time. This is a rare error in current versions of Microsoft Access, but began to appear in Access 2000.  

Deleting data in grids (sub-forms)

in

One of Access' best features is how easy it is to add related data sets. Forms frequently have embedded sub-forms or grids. Typically there are buttons for adding or editing rows in the sub-form If there is not a specialized button on each row for removing that row, you can still easily do so as follows. In a sub-form, there is a left-most grayed column, thin and empty. This is the row selector column. If you click next to a row in this left most column, the form responds by putting a right-facing triangle in the column, indicating you have selected that row in the sub-form.  

Creating off line data extracts

in

Often in an Access database, lists are presented either as Queries (data views) or Reports. These may suffice for many purposes, but it is also straightforward to then export them to Word or Excel. As with other things Microsoft, in fact, there is more than one route to doing this. All start by previewing the list on the screen.