I'm in a little bit of a spot here that I haven't been able to resolve on my own, I thought I'd get some advice.
I have a DB that retrieves only the accounts needed for a user from the Backend DB(due to the shared network drive being unusably slow with any more than 1 user on at a time). However, what I need to do in this instance is to use an INSERT INTO STATEMENT to retrieve Accounts on the server but then also do a LEFT JOIN with a table locally.
Here is the statement I have which is throwing an "ERROR in the FROM Statement":
SQL = "INSERT INTO Accounts SELECT a.*, t.* FROM Accounts a IN '" & DBPath & "AM.accdb' LEFT JOIN UnT t ON (t.SM = a.EmpName)"
I've also tried it with
SQL = "INSERT INTO Accounts SELECT a.* FROM Accounts a IN '" & DBPath & "AM.accdb' LEFT JOIN UnT t ON (t.SM = a.EmpName)"
With the same results.
Any help on getting this to work properly?