Using more than one Access accdb file

Posts   
 
    
timbered
User
Posts: 45
Joined: 09-Feb-2020
# Posted on: 23-Nov-2021 05:35:52   

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!

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Nov-2021 07:51:21   

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.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 23-Nov-2021 09:40:15   

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

Frans Bouma | Lead developer LLBLGen Pro
timbered
User
Posts: 45
Joined: 09-Feb-2020
# Posted on: 23-Nov-2021 19:35:35   

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.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-Nov-2021 07:12:42   

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.

David Elizondo | LLBLGen Support Team