'Table cannot be changed' messages

gadzilla1

Hello all,

I have the following messages that end users are experiencing:

'The Planning table cannot be changed because it is locked by another user. Wait until the user is finished then try again.'

also

'The Sales Header Archive table cannot...' etc.

Any ideas? I've asked around but no one seems to be running any processes in these tables.

Also, is there an area in Navision that may log these types of messages?

Thanks - gad1 (newbie learning quickly)

kriki

Are you running SQL or native?

gadzilla1

We are running SQL.

kriki

Probably the problem comes because of pagelocking. Try to put recordlocking on. (File=>Database=>Alter=>Tab Advanced=>Always rowlock=Yes). This should limit the locking problems. The negative for this can be that performance goes down a little.

gadzilla1

Thank you very much. Have a great day - gad1