'Table cannot be changed' messages

gadzilla1
gadzilla1 Member Posts: 316
edited 2007-08-01 in NAV/Navision Classic Client
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)

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Are you running SQL or native?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • gadzilla1
    gadzilla1 Member Posts: 316
    We are running SQL.
  • kriki
    kriki Member, Moderator Posts: 9,121
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • gadzilla1
    gadzilla1 Member Posts: 316
    Thank you very much. Have a great day - gad1

Categories