Linking to multiple Backends

[JACKSON]

Hi,

Has anyone every had a problem linking a frontend database to multiple backends ? I have a FE / BE database, and would like to split out a table or two into their own databases due to file size reasons. It seems to work fine, but I thought I would just ask if anyone have ever had a problem doing this in the past (i.e.e issues with ldb files ect... ??

Thanks

 

[Keith P]

Hi
I've run an app linked to 3 b/e dbs for several years without any problems. You should be fine.

 

[JACKSON]

Ok

Thanks !

 

[Pat Hartman]

Splitting into multiple be's is fine. Just be aware that you cannot enforce RI across databases so make sure that logical groups of tables are stored in the same be so that RI can be enforced.

 

[JACKSON]

Thanks !