Run time error 'Could not find output table ...

[Acie]

Looking for some advice.

I'm using VB6 with Access 2007.

Basically, I'm creating a table called user1_table within the code, then I
have an insert statement that stores data into this table. After the program
is done, it drops the table. When the program is run again, it creates the
table, and so forth.

Now, this program works fine the first time, and then it gives me the
Run-time error of '-2147217865(80040e37)' at the point of execution the
insert table query. BUt if i tell it to run from there (debug mode), then it
runs fine.

when the error occurs , I check to make sure the table has been created and
it is.

Any ideas?

Acie

 

[John Spencer]

Sounds as if you need a delay in your code to allow time for the table to be
built and recognized. If you were working directly in Access I would say you
need to use a refresh of the table collection and perhaps a DoEvents call to
yield some processor time for clean up before trying to do something with the
newly created table.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County