Error 3197

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

How do I avoid error '3197' (users are trying to update data at the same
time) in a multi user environment. I receive this error even when one person
is updating the database. What should I look out for when troubleshooting
this. I'm at wits end trying to figure this out..

Thanks in advance

Richard

--
 
Hi

Is your database setup in a FrontEnd/Backend configuration? If not you may
want to split the data out to a separate database.

Also, you might want to check your record locking strategy. Go to Tools /
Options, then select the Advanced Tab.

Your Default Record Locking should be set to Edited Record and your Default
Open Mode should be set to Shared.
 
Hi Maurice

Thanks for the advice. The database has already been split. I will try the
locking strategy.

Richard
 
Hi Maurice

I notice the locking is set at 'no locks'. Shouldn't that avoid the error?

Thanks again

Richard
 
Back
Top