Database slowdown if you connect to more than one BE?

[Dan2kx]

Just wondered really if connecting to multiple BE's makes the database slower in general? I have a project whereby i want to store information in 5 databases (site Specific) but i want some information to be in a common database.

Thanks for any info.

Dan

[ADezii]

Depenidng on the information that you require, why not programmatically Link/Break Links to specific DBs?

[Dan2kx]

Yeah i plan to be able to re-link the different databases, but i need one or two tables to be the same for all databases, this information shouldn't change much and should be quite limited in size, the bulk of the information should grow in these 5 seperate databases, just wondered if this would slow things down, the alternative would be to have this information in each database with some kind of syncronisation required (not best practice huh)

data is stored on a WAN by the way....

[Alireza355]

Programatically linking / breaking links to tables seems so interesting. Can you please provide more information? Thanx

[Dan2kx]

i do it like this, very simple:

Function ReMapTable()
Dim tdf As DAO.TableDef
    For Each tdf In CurrentDb.TableDefs
        If Mid$(tdf.Name, 2, 3) <> "Sys" And Left$(tdf.Name, 1) <> "~" Then
            tdf.Connect = ";Database=" &"**Destination**" & "##Database##"
            tdf.RefreshLink
        End If
    Next
End Function
 

that code relinks all tables to a given destination, i also use a function to select my locations, of course the code could be more complex... but i like simples...

Dan

[Stewart Ross]

Hi. In my experience linking multiple back-end databases does not of itself cause any performance deterioration to the performance of the front-end database. The linked back-end databases do not appear to be accessed by the front end at all until a query referring to tables from that database is executed.

I've seen no evidence so far of any polling or other checking of status of the tables concerned being done when forms etc referring to the linked tables via suitable queries are not open.

I use a reporting front-end system linked permanently to four different back-end systems located in different folders on a network drive with no apparent slow down from the links. Wish I could say the same about the network on which these are located, but that's a different issue!

-Stewart

[Dan2kx]

OK, thanks i will give it a whirl, i can see no other way of doing it easily really, i can maybe create temporary tables if it gets too slow.

Thanks