>What is the best way to avoid users trying to open a table that is someone else already has opened?

You users exclusive access to a complete table? Not a good idea?

>should I check and close the table first before I open it again.
>I am useing OTabale.State value every place I open a table and if is is open I close it.
>
>is this the right way to do this?
>
>If OLoginTable.State = 1 Then
> OLoginTable.Close
>End If
>
>OLoginTable.Open "Select * From UserInformation " & _
>"WHERE UserID = '" & Trim(Me.MSGFor.Text) & "'"

This code checks to see if the recordset is opened (not the table by another user).

Normally, you write multiuser application that allows a maximum number of users to share the same table. One of the best of acheiving this is to use SQL queries (INSERT, UPDATE, DELETE) instead of using equivalent ADO method which are locking a page (2k in Access).