dbFailOnError causes blowup on some PCs - not others.

  • Thread starter Thread starter msmcnewsxp
  • Start date Start date
M

msmcnewsxp

dbFailOnError caused an access app to blow up and create a backup on the
following line:

dbs.execute sql, dbFailOnerror.
(where the sql statement was updating a linked SQL table.

it only caused a problem with one user when he used his machine.
he could run a copy of the app on his hard drive or the same app from the
network and same problem.
he could run the same app from another PC logged in as himself and no
problem.

i removed the dbFailOnerror parameter and he has no problem.

why?
 
It sounds to me like a missing reference library on his
machine, but that's only a guess! To tell for sure you
would need to install access (the full blown applicatrion,
not the Runtime) on his machine, then open a code page and
under tools, pull up the references. Any library that is
missing will show up in the list as "MISSING". That word
will appear in front of the reference library name.

If it is shown a missing, then search for it on his
computer. If it is found, it is probably not properly
registered in the system registry. If it is missing, then
you will need to copy it from another computer (same OS
and Access veersions).
 
Back
Top