In Access 2007-Format databases (ACCDBs), the AppendOnly property for Memo fields allows you to store a history of the changes made to the field. The history of the Memo field can later be retrieved using the ColumnHistory method.
Category Archives: Microsoft Access Products
Speaking at Office Devcon 2009 in Australia Oct 31 – Nov 1
I’ll be giving several presentations on Microsoft Access application development and our products at the Office DevCon 2009 conference in Brisbane, Australia at the end of the month. Hosted at the University of Queensland, St. Lucia campus, I hope you see you there!
For more information, visit our Upcoming Events page.
Access Tip: Reference Tab Pages by its PageIndex Rather than Tab Value on Microsoft Access Forms
Here's a simple tip to avoid problems associated with referencing the individual pages (tabs) of a Microsoft Access tab control in VBA.
Tabs are powerful and easy to use on Microsoft Access forms. A tab control contains pages (tabs) with each page identified by its PageIndex property starting with 0. The value determines the order of the tabs. However, if you reference the pages by number, your code may fail if the pages are reordered, new ones added or pages deleted.
See how you can avoid this problem and read about other tips for creating better and faster Access forms.
FMS Papers Featured on MSDN
Microsoft recently added three of our technical papers to their MSDN (Microsoft Developer Network) web site:
- Microsoft Access Query Tips and Techniques
- Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6)
- Microsoft Access Performance Tips to Speed up Your Access Databases
We're proud Microsoft recognized our work and look forward to sharing more resources with the developer community.
Tip for Access 2007: Use “Check for Truncated Number Fields” for Partially Displayed Numerical Values
In Access 2003 or earlier, you may have seen truncated numbers on forms or reports, and not realized that you weren’t seeing the full value. Access 2007 includes a new option to check for truncated number fields and display pound signs (#) to indicate that the entire value is not shown.
Errors Importing Data from a Microsoft Access 2007 Format File into SQL Server
While attempting to import an Access 2007 format database (*.ACCDB), you may receive an error such as: Unrecognized Database Format or Could not find installable ISAM. These errors can occur if you do not have the appropriate driver installed to import data from ACCDB files.
Importing Microsoft Access MDB databases into SQL Server is a built-in feature of SQL Server. However, because of the difference between the database engine of Microsoft Access 2007 and earlier versions of Microsoft Access, it is not possible to connect to the Access 2007 database using the built-in data source “Microsoft Access”. You can use this if you wish to import data from a MDB format, but not an ACCDB from Access 2007. For more information, check out Errors Importing Data from a Microsoft Access ACCDB Database Format into SQL Server.
Importing Access 2007 Tables into SQL Server
Microsoft SQL Server 2005 offers the Import and Export Wizard to move data from one source to a destination. With the Import and Export wizard, you can access different types of data sources. These sources include other database formats such as Microsoft Access, Microsoft SQL Server, flat files, Microsoft Excel or Oracle database.
Total Access Detective Versions X.7 for Access 2003, 2002, and 2000
With the recent release of Total Access Detective for Access 2007, we're pleased to provide new versions for Microsoft Access 2003, 2002, and 2000 (versions 11.7, 10.7 and 9.7 respectively).
Version X.7 adds many new features including data comparison between two queries, enhanced data comparison options such are comparing two tables when field names are not identical (compare only identical field names or on field order), using the first field as the key field if no key field exists, skipping small numerical data differences, ignoring case differences between modules, improved support for ADP comparisons, etc. Existing customers can upgrade for a nominal fee.
Existing Total Access Detective customers under annual support contracts receive the upgrade for free.
Adding Commonly-used Command Buttons to the Office 2007 Quick Access Toolbar
In Microsoft Office 2007 programs (Access, Word, Excel, PowerPoint, etc.) the Quick Access toolbar in the upper left corner offers shortcuts to several commonly-used toolbar buttons or commands. By default, it just shows Save, Undo, and Redo. However, you can customize this to add commands that you use often.
Layout View in Microsoft Access 2007
Microsoft Access 2007 comes with many new features to make your Access application more impressive. One of the new features in Microsoft Access 2007 is Layout View, which allows users to design forms and reports more easily.