Hi Eric,

Since you seem to know a lot about how VB and databases work, can you give me some ideas on this issue.

This project I am working on(VB and Access database), The database going to be on a server and many users will access the tables in the database.

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

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) & "'"


For a single user this works ok, but I have not tested it on the network yet.

Thank you Eric. :)