ms access - MSAccess - dbSeeChanges error? -


i have database has been working couple years until morning. when attempt copy contents of remote table local backend, presented err: "error 3622 - must use dbseechanges option..."

the remote table on server , have autonumber attribute. backend table simple readonly/static snapshot not care auto numbering datatype , defined number - need table (snapshot) local performance concerns.

i added dbseechanges variable without success - complains "too few parameters" on db.execute line (below).

here details db:

dim db database dim strsql string set db = currentdb()  strsql = "insert item " & _     "select dbo_item.* " & _     "from dbo_item " & _     "where dbo_item.master_invid=  " & tempvars!my_invid      db.execute strsql, dbfailonerror + dbseechanges 

what missing? suggestions avoid/correct.

another way make copy of linked table covert local table:

localtablename = "item" docmd.copyobject , localtablename , actable, "dbo_item" docmd.selectobject actable, localtablename , true runcommand accmdconvertlinkedtabletolocal 

Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -