Access VBA ADO .Edit Causes Error 3197 that Continues Successfully
Posted on 2014-01-20
I confirm only one user on the network (no lock file - plus no one else ever runs the report) and the Access database throws an error 3197 on an ADO .Edit statement. JUST CLICKING START BUTTON ALLOWS THE PROGRAM TO CONTINUE TO A NORMAL FINISH. So the problem is just that the program stops with the bogus error 3197 but resumes without incident.
The code hasn't changed, but I am running Access 2010 now whereas I was running 2007. Also, a new Windows 2012 file server. The same domain user can run this successfully on the file server directly.
Nothing logged in the event log for either application or system on the server or the workstation.
I would appreciate ideas what could cause this.