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!

 

[Pat Hartman]

Speed doesn't enter into the equation since there is no option. If you are linking to the tables, the connection needs to be in the FE. If you are running code to import the tables, the connection would be in whatever database is doing the import.

 

[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