Now, once i get to this point, how do i create the links to the external data? TransferDatabase() doesn't seem to like that connect string, and i can't find any references to link tables using ADO or RDS.
I would use the Access GUI to link the front end and back end databases.
Open up your front end database. Click on the File menu and select Get External Data and then select Link Tables. Find the backend DB file and select <theTables>.
@ FE database in Tables you'll see the arrows next to the tables which means this FE is linked to these tables.
You can verify the path or point to a different backend DB in Linked Table Manager window. Click on Tools menu and select Database Utilities, then select Linked Table Manager.