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. :)