Splitting My Access DB - ODBC Connection

[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]

Duplicate thread.