Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 103 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by saradavid
Member Avatar for 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

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.