access gives error 3192 running query on a newly created table
In VBA I create a new table in a remote database. Also in VBA I create a link to this new table.
This all works until I run a query to insert data into the new table, I get error 3192 " table or query name not found".
BUT if I restart the program several times, then it all works great