If you’re interested in testing on-premises SharePoint Server 2010 with Access Services for Access Web Databases, Bruce Kyle posted How to Set Up SharePoint 2010 Developer Machine without Hyper-V to his US ISV Evangelism blog on 3/11/2011:
SharePoint Easy Setup Script is a new tool released by Chris Johnson and Paul Stubbs to help you set up a SharePoint 2010 developer machine without requiring Hyper-V. The Easy Setup script will set up the machine, either as a native install or on a bootable VHD file.
Paul and Chris have a video on Channel 9 that shows you how. See Building a SharePoint Development Machine Using the Easy Setup Script.
In order to make this process as easy as possible, we have created a series of PowerShell scripts that automate the entire process of building a fully running and ready-to-go SharePoint 2010 environment. The scripts are highly configurable, but out of the box they will download all of the required software and install all of the SharePoint prerequisites as well as other software such as Visual Studio and Office. The script will then install and configure SharePoint 2010 and, finally, the script will provision a site.
Download the Easy Setup Script
For More Information
ISV Video on SharePoint development, see Quark Extends SharePoint for Dynamic Publishing.
For Free Assistance with SharePoint 2010
Join Microsoft Platform Ready for free assistance in making your applications compatible with SharePoint 2010.
Also see the SharePoint Developer Center on MSDN for videos, training, and how to get started with SharePoint development.
Bruce is a Microsoft ISV Developer Evangelist.
The Specs for my Primary Development Server
My self-assembled development machine has an Intel DQ45CB 64-bit motherboard, an Intel Core2 Quad Q9550 processor (2.83-GHz, 12M cache, 1333 MHz FSB) with VT-x and VT-d, 8 GB DDR RAM, and two 750-GB Seagate SATA-2 drives in RAID1 configuration with the on-motherboard RAID controller. I run SharePoint 2010 Server on a Windows Server 2008 R2 virtual machine with 4 GB RAM assigned by Hyper-V under Windows Server 2008 R2 as the host operating system. I’ve been very pleased with the performance of this machine.
The VM also runs SQL Server 2008 R2 Standard Edition for testing upsizing Access 2010 databases to SQL Server.