Could not find output table error

Discussion in 'Microsoft Access VBA Modules' started by Van T. Dinh, Sep 25, 2003.

  1. Van T. Dinh

    Van T. Dinh Guest

    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.

    Van T. Dinh
    MVP (Access)
    Van T. Dinh, Sep 25, 2003
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.