Database engine could not lock table issue

[ganeshvenkatram]

Hi I Got the following error

"The database engine could not lock table 'Table Name' because it is already in use by another person or process"
i got the above error statment when i execute the following poece of code]

Private Sub Form_Load()
    CurrentDb.Execute "ALTER TABLE tbl_PaperTeam ALTER COLUMN ID COUNTER(1,1)"
   ME.AllowEdits=false

[pctech33]

Hi,

make sure the table is not open. and try that..
Sometimes when access tries to change the data in table and u try to ask it to do another process then it gives this error message.
So make sure table is not open in datasheet view.
hope this helps.

[ganeshvenkatram]

Hi,

make sure the table is not open. and try that..
Sometimes when access tries to change the data in table and u try to ask it to do another process then it gives this error message.
So make sure table is not open in datasheet view.
hope this helps.

Hi Thanks for ur reply.

Im sure that the table is not opened when executing the code.i have assigned the Form as my project startup. Even its throwing that error.

Can u give any other Suggestion.