Sharing MS Acess DB on multiple computers

Discussion in 'Hardware' started by Layzie Bone, Nov 21, 2008.

  1. Layzie Bone

    Layzie Bone Private E-2

    We have two identical computers, running Windows Vista and MS Access 2000. I have a DB file shared over thier network, and have mapped a network drive on that computer, when the DB is open on both computers i cannot save the changes on either computer, how can this be done?
     
  2. buggabear

    buggabear MajorGeek

    I don't think you are going to be able to because you are sharing information real time. The DB cannot update itself if the other one is currently using the same DB. You can save the file to your own computer then when he other is closed upload it and save it.
    You can also try to choose a different location on the server to your file verses the default location.
    I'm in no way an expert on this so hold on and maybe someone else will come through with a better answer
     
  3. foogoo

    foogoo Major "foogoo" Geek

    At my work I inherited a "quote system" that someone at the company wrote, it is an Access DB and they use Citrix so multiple people can connect. So I'd say you need to run some terminal services to make it work.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds