Hello!

The Llblgen designer allows a database driver to be added only once to a project. The driver for "MS Access (OleDb)" only allows one ".accdb" file to be attached to it.

Is there a way I can access two accdb files from one Llblgen project, instead of having to create two separate Llblgen projects, one for each accdb file?

Thanks!

Yes, there is only one DB per database type. If you have more DBs of the same type you should consider if that is part of the same model. Or, you could join the databases outside and group tables per schemas. Also you could use views to map.

For Access this isn't possible, as you can't use multiple database files per connection

Ok, thanks for the info.

The usage case is I'm moving data from one DB to the other, that's why they are different physical files. Same model in both, though. And, I didn't design these, I inherited them.

It's a pretty esoteric situation, so I'm not surprised it's not possible.

Are you using Adapter or SelfServing template set?

If you use Adapter, and as both DBs has the same schema, you could use the DataAccessAdapter constructor that accepts the connection string, so you have two adapters connected to diferrent DBs.