We've got a new client requirement to support more than one Access DB in the same Adapter .lgp. When creating the project, the option to add more than one catalog doesn't seem to be allowed. Is there a way to add multiple catalogs if the database is Access?

We currently have considered changing the connection string on the fly, as one database will contain the total schema, and the other, just a subset of the tables.

If not, what might be a good alternative?

Thanks!

We currently have considered changing the connection string on the fly, as one database will contain the total schema, and the other, just a subset of the tables.

Using a file based database like Access, I think that's the only way.

Ok... thanks for your answer Walaa... we began implementing code yesterday and refactored our business logic to support a factory approach to changing the connection string. Seems to work well enough.