>Hi friends
>
>Can anybody help me so that I can open a table in such a way that no other user can open it (read-only mode is also not allowed) or lock a record so that no other user can read or write on it till it is released.
>

You can open table in exclusive mode.

USE mytable EXCLUSIVE

However, any other user trying to open that table will get "access denied" error.