What I have done is to include the following codes in the Form_Load()
Dim pwd As String
Dim Dbs As DAO.Database
Set Dbs = DBEngine.OpenDatabase("<BE File Location>", False, False, ";pwd=<password>")
DoCmd.TransferDatabase acLink, "Microsoft Access", "<BE File Location>", acTable...