1) Data Junction (or it's newer replacement product) can transfer information between Access and salesforce.com. (see the Data Junction discussion group).
2) You could use the API to roll your own solution.
3) The up-coming Office Toolkit (COM support) could probably, when available, be used effectively from with Access. This facility allows the sf.com API to be called from VBA and has been used to build a comparable facility within Excel. This would not be trivial, but could be much easier than (2). See topics in the Visual Basic discussion group for what information is available on the toolkit.
Drober,
1) Data Junction (or it's newer replacement product) can transfer information between Access and salesforce.com. (see the Data Junction discussion group).
2) You could use the API to roll your own solution.
3) The up-coming Office Toolkit (COM support) could probably, when available, be used effectively from with Access. This facility allows the sf.com API to be called from VBA and has been used to build a comparable facility within Excel. This would not be trivial, but could be much easier than (2). See topics in the Visual Basic discussion group for what information is available on the toolkit.
Scot
Drober;
You are welcome to use our tool free for a week to update salesforce.com from Access. You can get it from www.demandtools.com.
GlennW