Thanks for responding. As I said I am very new to programming. I had developed a vb6 form based application with access db. this application runs well on a stand alone machine. If I have to make it run on lan where multiple users can use the application how would I make it? This is precisely the issue on which I need your help please.
the short answer is that all you need to do is simply put the Access database on a shared folder on the network that everyone has read/write access to... then change the connection string to point to the new location.
That's the short answer. The longer one echoes the warning by Gremlin regarding corrupt data... Despite what people say, when you have multiple users in an Access database at the same time, it's not a matter of IF the database will become corrupt, it's a matter of WHEN. The more users you have, the faster it will happen.
The old versions of Access would corrupt data with more than 3-5 users at once. The new version just refuses to allow more than the limit, due to throttling. SQL Express does the same thing, except with their minimum, around 50, I think. Over that needs SQL SERVER paid version.