I want to access data from a network computer in window application

  • Thread starter Thread starter sonu
  • Start date Start date
S

sonu

I am working with a window application which will run on every computer
on a network.

but data will be only one machine on network.
i am giving in connection string like..

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Inetpub\\wwwroot\\project\\combo.mdb";

it is working only that machine where data "combo.mdb" and is not
working other machine on network

Any help plz

Regards
Sonu
 
Sonu,

Right, because C is a local drive. What you want to do is place that
database file on a network share, and then access that in your program, like
this:

\\my_machine\shared\data\combo.mdb

Also, it should be noted that if you have more than a few machines
accessing the same MDB file at the same time, performance is going to be
horrendous, and you should consider moving to SQL Server (you can use SQL
Server express if your organization is not that large). You will get MUCH
better scalability.

Hope this helps.
 
Back
Top