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.
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.
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
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.