How can I make ONE database be updated from multiple terminals connected through a LAN network? How can I access the database through a LAN network in visual Basic 6?
navogatoo 0 Newbie Poster
kinwang2009 7 Posting Whiz in Training
You can use server and client system. Database you want to update will be in Server PC and use winsock to update data at server.
debasisdas 580 Posting Genius Featured Poster
what is the database that you want to use over LAN ?
navogatoo 0 Newbie Poster
debasisdas: lets say its a database that holds records of repaired computers in a service centre. The service centre is connected to the computer shop with a LAN connection. So when the people in the service centre changes information in the database, it needs to be updated in the shop as well. In other words, the shop needs to know the status of computers in service centre, whether they are repaired or not.
debasisdas 580 Posting Genius Featured Poster
I was asking about the database that you are using (access, sql server, oracle etc) not the contest of your database.
jhai_salvador 48 Junior Poster
If the database is Access then all you have to do is Share its folder and make it writable so it can be access through lan connection...
joshuaramirez 0 Newbie Poster
debasisdas my database is Microsoft Access 2003.. I also want to update to update my database in one server since it is connected to multiple terminals. I need a solution for this problem for my thesis project. :(
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.