MS Access Resources

[Heather]

For those of you who are new to MS Access database design, Microsoft recently posted are fairly basic introduction to "thinking relationally." Here's the link: http://office.microsoft.com/download/afile.aspx?AssetID=AM102835081033

[Heather]

On the Access Team Blog (http://blogs.msdn.com/access/archive/2008/09/16/access-2003-and-2007-hot-fixes-are-available.aspx) this morning, hot fixes for the following issues in Access 2007 have been made available:

Access 2007


In Access 2007, you create a query that does not contain a parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
You have a printer that has a staple feature. When you print an object in multiple copies in Access 2007, all the copies are stapled as one unit. However, you expect that each copy is stapled individually.


For more information, please visit Microsoft Help and Support. (http://support.microsoft.com/kb/956054)

[Heather]

New hotfix released on October 28th, 2008. Click the below link to read about which Access 2007 issues it fixes!

http://support.microsoft.com/kb/957690

[Heather]

This particular hotfix will address the following issues:


You experience slower performance than you did in previous versions when you share a database file over a network.
You may notice your database file increase in increments of 4 KB without any user interaction when the database is open.
You may see a sub-form become blank after you set the main form’s recordset. You may also receive the following error: “Run-time error 2467 – The expression you entered does not exist”.
When you make a change in a code module in an Access 2007 database under source code control, the changes are not saved if you do the following:
Close the Visual Basic Editor without saving the changes
Check the Object back in
Use the Get Last Version feature to view the latest changes.


To obtain this hotfix, please visit http://support.microsoft.com/kb/960307