multi-user app

[Melanie]

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 :

Dim con As Connection
    Set con = New Connection
    con.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & vectPref(2)
    con.Open

Thanks in advance...

[nabeels786]

why not have them access it a split second after each other?


if its on your computer, you might have to set the permissions to the database correctly, i think windows 2000 has the option

[Melanie]

Hi,

Thanks for the reply. The database works on a server. And which permission do I have to set to the DB in the code for 2 or more users add a record?

Thanks

[Melanie]

Nobody?

[seoptimizer2001]

Try using adLockOptimistic on the recordset LockType.