Microsoft® Access 2010 physical file sizes

Write on the new file format and features of Microsoft Office Access 2010. Also discuss the older file format version.

Microsoft Access 2010, by default, makes use of the .accdb file format extension which was earlier introduced in the Microsoft Access 2007. Microsoft Access continues to provide some support to the file format which was used in earlier versions of Microsoft Access. The Microsoft Access 2010 employs a file format which supports a number of advanced product enhancements. As you create a new database, the database makes use of the new file format by default and is given the .accdb type of file extension. You need to use the new file format whenever possible because it supports advanced features such as multivalued fields and attachments. Also, if you want to convert your desktop database to a web database by using Microsoft Access services, the desktop database file must be in .accdb format. But the new file format cannot be opened or linked to or with earlier versions of Microsoft Access; it doesn’t support replication and it also doesn’t support user-level security. If you need to use the database with earlier versions of Microsoft Access, or if you need to use the replication or user-level security, you need to use an earlier version of the file format.

New file format, features of Microsoft Access 2010, and older file format:

• Memo field history tracking
• Improved encryption
• Earlier file format version

Memo field history tracking

The Memo fields are helpful in storing large amounts of information; starting with Microsoft Access 2007, you can set the AppendOnly property which forces Microsoft Access to retain a history of all the changes to a Memo field. You are then allowed to view the history of those changes. The feature also supports the versioning feature in the Windows SharePoint Services 3.0 so that you can make use of Microsoft Access to track changes in multiple lines of a text field that is stored in a SharePoint list.

Improved encryption

You are allowed to set a database password and encrypt the contents of your database. When you choose it using Microsoft Access 2007 and a file that uses the new file format, Microsoft Access makes use of the the Windows Crypto API to encrypt the data. You can also make use of third-party encryption tools.

Earlier file format version

The earlier versions of Microsoft Access other than the Microsoft Access 2007 support file formats that use the .mdb file extension. The Microsoft Access 2007 makes use of the .accdb file extension. By using the Microsoft Access 2010, you can still open .mdb type files. If the file is stored in the Microsoft Access 2002-2003 or Access 2000 file format, you are still allowed to open it and use it in Microsoft Access 2010 services as you normally would. But, you cannot take advantage of the new features that require the .accdb file format.

iYogi’s Annual Unlimited Subscription Plan

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.

Our award winning and low priced Annual Subscription covers the following services :

• Comprehensive support for Microsoft Access 2010 physical file sizes
• Diagnosis & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices, and peripherals
• Optimize your computer’s speed and performance.