Urgent : File already in use

[pardeep3dec]

Hi friends,
I am using travelmgmt.exe file of visual basic project on LAN. In project i can add record,edit,search and delete record. I want make my project multiuser but when i use travelmgmt.exe file on LAN it shows message File already in use

Please tell me the way of making it multiuser . I am using adodb whose connection coding given below.

Dim db As New ADODB.Connection
Dim rc As New ADODB.Recordset
db.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& App.path &"\tmgmt.mdb"

Please help

[aktharshaik]

Try This

Dim db As New ADODB.Connection
Dim rc As New ADODB.Recordset
[B]db.CursorLocation = adUseClient[/B]
db.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& App.path &"\tmgmt.mdb"

Regards
Shaik Akthar

[saradavid]

Try This

Dim db As New ADODB.Connection
Dim rc As New ADODB.Recordset
[B]db.CursorLocation = adUseClient[/B]
db.open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& App.path &"\tmgmt.mdb"

Regards
Shaik Akthar

Check whether or not the file is opened in MsAccess on the other computer. Restarting the computer on which the file resides will probably solve the problem.

Another possible reason may be that someone has made an exclusive connection to the mdb file. If it is the case, you should close other exclusive connections to the mdb file and then try to connect.