Getting Ready for Microsoft Access 2010

Deploying your MS Access 2010 databases to the web will require more than just Microsoft Access, as would be expected.  Below you will find a summarized list of software requirements as published by Microsoft to date.
 
Users' PCs
No surprise here, the biggest excitement around Access 2010's Access Services feature is that your average users that need to view, query, or update information in your database won't need any more software installed but a browser.

Developers' PCs
Anyone that will need to manage your database tables, forms, queries, and reports will need the full version of Microsoft Access 2010 (32- or 64-bit edition).  That includes:

• Creating or editing table structures, relationships, and Access data macros
• Creating or editing Access web forms, Access web reports, and queries
• Designing and running complex queries
• Running any Visual Basic code

Web Server
Publishing Access 2010 forms to the web will require Microsoft Office Share Point Server 2010.  Share Point Server 2010 comes only in a 64-bit configuration, which means your server(s) will need to support Windows Server 2008 Standard (SP2).  The full list of software requirements can be found on Microsoft's site, but we have summarized the major requirements below:
 

• Windows Server 2008 R2 ($680+ USD list price)
• Microsoft Office Share Point Server 2010 (list price not available yet)
• SQL Server 2008 Express with SP1 (free) or any higher edition of SQL Server 2008 (list prices vary)

If you plan to make your Access 2010 web application available over the public Internet (not just your internal intranet), you will need to license 'Microsoft SharePoint Server 2010 for Internet Sites, Standard Edition,' instead of the standard edition.