[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

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
0
durick
Asked:
durick
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You have to Refresh the Tabledefs collection after you add a new linked table:

Currentdb.TableDefs.Refresh
0
 
Gustav BrockCIOCommented:
Or even:

DbEngine(0)(0).TableDefs.Refresh

/gustav
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now