Store odbc connection in FE or BE?

[armesca]

I have split a few different MS Access databases before with the BE on a shared drive and the FE installed on all users' local machine. In this instance, I have three ODBC connections bringing in data to my tool from an outside database once a day. Does anyone know if it is faster to store the odbc connections on the FE or BE when I split them? Or will it be the same? Thanks!

 

[DavidAtWork]

you may also want to consider using DSNless connection strings (if you don't already) as this will negate the need for any ODBC DSNs to be set up on the users machine

David