hi everyone, I wish to share the mdf file on the network so that other computers can use the file to capture or retrieve the data. Is there any way I can do this on MS SQL SERVER 2005?

Yes you can if you have a fixed IP address then you can make your mdf file use as server. So that each client connect the database....

I'm curious, why share the mdf and not connect to the SQL server?

thanks for your response guys, adam can I still connect on the mdf file if I don't have a server. I use three normal computers with windows xp on it and I want to use the other pc to host the mdf file. Kingsonprisonic can this be possible?

You can't really just "connect" to an mdf file. The mdf file is "owned" by a database engine instance that accepts requests, retrieves data from the mdf file and delivers it to the requester. What your "normal" machines have to connect to is the database engine that owns the mdf file.

Depending on how your network is configured, you can reference that database engine instance by name, or (as @kingsonprisonic says) by the IP address and port of the machine where the database engine instance is running (assuming you have proper security permissions on that SQL Server instance).

I hope that was clear enough?

For this limited number of PCs (and from that I assume also limited number of concurent connections can be achieved) you would need an Express edition SQL server. Its free and it's major limitation is the number of concurent connections, which doesn't seem to be a problem.
You can have your clients connect to the service and the server will take care of the data.
Trying to share the db my sharing the mdf file will get you nothing, as BitBlt has already explained.

thank you very much guys, now everything is clear, from your answers I can tell where I was making a mistake: I created an mdf file using SQL SERVER, then extracted the mdf file and located it to the other hard-drive, my mistake was there. now I understand that I have to leave it in the SQL SERVER and connect direct to the sql server. I will try it and I don't doubt it will work. thanks A LOT.

Be a part of the DaniWeb community

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