Hi,

I know that I'm not in the good section, but in the database section it's very long to have an answer...

I have an Access database. I want 2 or more users to be able to ADD records in the same tables at the same time but I get an error which said that the database is exclusively open by another user...blabla. What option do I have to put in the open of the database? The only thing I want to lock it's if 2 users are in the same record...that's it. No other security.

I open my database like this :
VB Code:
  1. Dim con As Connection

  2.     Set con = New Connection

  3.     con.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & vectPref(2)

  4.     con.Open

Thanks in advance...