There is a much improved solution for this in Office 2007. For any application based around data tracking and where offline support is a requirement, SharePoint 2007 and Access 2007 plays together very well. Access can be bound to SharePoint lists. This gives you the server-based benefits of SharePoint and provides you with a rich UI and offline support.
To start exploring this functionality try the following:
- Create an Issues Tracking list in SharePoint.
- Add some sample data to it.
- From the Actions menu, select Open with Microsoft Office Access.
- An Open in Microsoft Office Access dialog pops up. Make sure Link to data on the SharePoint site is selected and click OK.
The data is still linked to the SharePoint list. To take the data offline click Take All Offline on the External Data ribbon. You now have a local copy of the issues list including a rich interface to interact with it. The data is saved locally only.
At any point in time, you can hit the Synchronize button on the External Data ribbon which will synchronise the data with the SharePoint list on the server. If there are any conflicts, a Resolve Conflicts dialog will allow you to resolve them.
All in all, SharePoint and Access together provide a powerful and simple solution for data tracking. SharePoint enables proper sharing and backup of the data and Access provides a rich UI and offline support.