Archive for the 'Access' Category

Where’s That Feature: Access

Microsoft has an interactive web site that shows you where a feature in Microsoft Access 2003 can be found in Microsoft Access 2007.  Just click on a toolbar button or menu item and the site shows you where that feature can be found in the new version.

Access Database Locking Issues

 Sorry for the vagueness on this one, but I’m not quite sure how the database was set up previous to the Office upgrade.

With older databases that had a hide/unhide feature in order to edit and add records you might have some issues.  One way (and the best I’ve found so far) is to right click on the title bar of the window and click on “Design View” and then switch back to whatever view you were in originally.  You should now be able to edit records and add new ones (the “Add New” button is up in the ribbon on the Home tab).

Where have my macro settings gone?

Here’s a quick visual to help you find the odd place where your Access macro settings have ended up.

Access Macro Settings