We are moving from an old (obviously) Access 97 database to SQL 2005. During the transition it will be necessary to keep both databases up to date.

Ideally, I would like to automatically update the Access database directly as part of the Commit process in the SQL 2005 transaction. I think I can use attributes on the classes to determine whether I need to make the separate call to Access or not.

I have seen some suggestions on how to use two configurations for separate databases but can't seem to get that working. When I try to set up the 2nd configuration with the Access dialect it defaults to SQL 2005 instead.

Has anyone tried to accomplish this type of dual update?