0

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
3
Views
8 Years
Discussion Span
Last Post by saradavid
0

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

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.