Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Access Team Blog

Get product announcements, tips and tricks, and news directly from the team @ Microsoft.
A new hot fix for Access 2007 is now available

Issues fixed include:

  • 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.

These fixes are available at http://support.microsoft.com/kb/960307.

Posted: Tuesday, December 30, 2008 10:06 AM by Clint Covington
Filed under:

Comments

Tony's Microsoft Access Blog said:

A new hot fix for Access 2007 is now available But I shouldn't have needed to tell you this on my

# December 31, 2008 5:39 PM

CyrusB said:

Does anyone know if this hotfix can be rolled-back (i.e. without having to do a full re-install of MS Access)?

Thanks.

# January 2, 2009 4:22 AM

Renaud Bompuis said:

Does this fix address the Runtime version as well? It doesn't seem to say whether it does or not in the notes.

# January 5, 2009 2:05 AM

David Webb said:

I've just upgraded from Access 2003 to Access 2007. I have alread installed the latest hotfix (960307).

I have a front-end mdb with a few small tables in it, and most of my large tables are in a back-end MySQL database using linked tables and views in Access. The big performance problem, compared with Access 2003 (which was good), is with combo boxes in datasheets. Navigating a datasheet (whether seperately or in a Form) is extremely slow, like wading through treacle. If I convert all the combo boxes to text boxes then the problem goes away - but then I am looking at raw identifiers (index keys) rather than data a human can use (like a company name). The difference from Access 2003 seems to be that each time you navigate to a new record on the datasheet, Access 2007 performs a new query on the linked table for all combo boxes, whereas  Access 2003 was smart enough to re-use the previous recordset since it "knows" that the lookup table for the combo box probably hasn't changed. That's my guess anyway.

Please can you let me know whether you are aware of this problem and if so what you are doing about it. It spoils an otherwise good product.

# January 6, 2009 12:06 PM
New Comments to this post are disabled
Page view tracker