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!