Help!?
In desperation I have turned to this forum.
I have a complex Access DB with tons on VBA code.
It is working very well with Access 2007.
I recently upgraded to Access 2010 and the system now
fails miserably in several ways, mostly due to write/update
conflicts.
I'm getting errors 3188, 3197 and 2118 where I never had these
before. These are all about a record being changed by someone
else even when I'm the only one using the system on my laptop.
I'm either missing something completely or something has changed
with this version of Access to make things fail like this. The failures
typically happen on a "Requery" of a form after data in a subform has
been changed that also changed data in the main form.
I've searched many threads on the web for these error codes and
found little that explains the problem or how to fix it. Hopefully it's
a simple "setting" that is wrong and not massive code changes.
I've looked at "locking" options (no changes between 2007 and 2010
that I can see) but have not looked into "autocommit" whatever that is.
Some guidance and a fast fix would be much appreciated.