Connect a System and Database into a LAN or Workgroup

Hello programmers and developers :) Is there anyone who knows how to connect the system to a LAN? Example: I have 15 units and I install all of this my system but the database is my problem. My questions is, is it possible to modify other users the records in one database in lan connectivity at the same time? How can I do this? My idea is I shared my folder which includes the system, into workgroup or LAN? And is possible input a records even the database is in read only mode? Free to leave a comments and suggestions Thanks
Submitted byadminon Fri, 03/22/2013 - 12:06

All you need is to share the folder where the database is located. I have already discuss this in this link: http://www.sourcecodester.com/blog/how-map-network-drive.html Additionally, you cannot of course update a read only database, hence the word read only.
Submitted byAnonymous (not verified)on Fri, 03/22/2013 - 13:56

in my experience i had first create a user account, dedicated for only allowed user who can read and write on my database, on shared folder properties "sharing and security" i just add the user's and their permission (optional) for you to give in every user, whether you want them just to read your database, etc., And Only the user you created who can only access in your system and database with restriction, hope i could help...
Submitted byanonymouson Sat, 03/23/2013 - 11:09

Thank you admin :) I’ll really appreciate your advice but is it possible to replace an existing database with a new one but with the same file name of my database?

Example a have a large amount of records in excel but I want it to copy or transfer it into my database immediately, therefore I can transfer it to my database manually using my code but one by one so it's hassle, at a time but in a running system the database is in read only mode right ? So my idea is i have a copy of that existing database and I paste my records on it and I replace my existing database with my new one with a records I include . Do you think it's possible? Sorry I can't speak English fluently im’ a Filipino haha :)
Submitted byAnonymous (not verified)on Sun, 03/24/2013 - 14:06

Just,.make a static ip address in you LAN e.g.(192.168.1.1) then share it to your clients.,no need to share the folders as long as you are networked each other...in only one database; just text me if need more answers to fix your answers..to my mobile number +639075790118
Submitted byanonymouson Mon, 03/25/2013 - 09:45

In reply to by Anonymous (not verified)

Thanks for response :) is static IP address works on this? I've already made a running system for my client and I used visual basic 6

Add new comment