I've never worked with Sharepoint.
However, the first line of your code imports tables as local anyway
So the other two lines are I believe redundant and are I think the cause of your error
This should be all you need:
DoCmd.TransferDatabase acImport, "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0
To link to an external table, use acLink rather than acImport
Then the other two lines will convert it to local without error.
DoCmd.TransferDatabase acLink, "Microsoft Access", FPath, acTable, "SchoolList", "AccessTbl", 0
DoCmd.SelectObject acTable, "AccessTbl", True
The simplest way of converting linked to local involves no VBA.
Right click on the table in the nav pane and click 'Convert to Local Table'.
Just make sure the table isn't in use when you do so