Error 3197

[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

--

 

[StCyrM]

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.

 

[Richard]

Hi Maurice

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

Richard

 

[Richard]

Hi Maurice

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

Thanks again

Richard