Microsoft Access 2010 introduced a new version of the accdb format supported hosting Access Web solutions on a SharePoint 2010 server.The linked tables in the front end point to the back end file.

40 This issue severely affects query performance on both Access 2003 and earlier with the Jet Database Engine code, as well as Access 2007 and later with the Access Database Engine (ACE)."Chapter 5 - System Requirements for MS Office".For very large Access databases, this may have performance issues and a SQL backend should be considered in these circumstances.

In the database container or navigation pane in Access 2007 and later versions, the system automatically categorizes each object by type (e.g., table, query, macro).However, certain data types are problematic, most notably "Yes/No".This allows Access developers to create databases that can be freely distributed to an unlimited number of end-users.