Yes, you'd generate the code once for MSSQL and once for MSAccess, and use only one of those generated DBGerenric dlls. (they should be identical, if the schema are identical).
Then by using a config file or so you may detect which DBSpecific dll to use with the corresponding connection string.