Could not find output table error

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
V

Van T. Dinh

Is "H:\Project Numbers\Project Number Master.mdb" the
Current database?

If it is, then you can simply use:

Set dbs = CurrentDb()

rather than the OpenDatabase statement.

If it is not, then your INSERT SQL statement won't work as
JET will look for the "tmptbl1" in the Current database
and you get the error posted. You need to use the In
Clause (check JET SQL Reference in Access Help) to specify
the location on the "tmptbl1".

After fixing the above and if it still doesn't work, try
the statement:

DBEngine.Idle dbRefreshCache

after the statement dbs.Close in your code.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top