Page 1 of 1

Sharing MS Acess DB on multiple computers

Posted: Fri Nov 21, 2008 9:09 pm
by Layzie Bone
How would I be able to not just share but to be able to work with the file simutaneously on 2 computers. It is a MS Access 2000 file, and the computers are running Windows Vista, any pointers?

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?

Re: Sharing MS Acess DB on multiple computers

Posted: Sat Nov 22, 2008 2:29 am
by battye
I found this page, which might help (if you are registered there): http://www.experts-exchange.com/Microso ... 28107.html
Here's another page: http://www.eggheadcafe.com/software/asp ... uters.aspx (this one might be more helpful?)

I've only ever used Access as a single user, my concern is that if you have two people editing the same file there will be a lot of problems including data duplication. One of the users responses in the second link suggests splitting the database, could be worth a thought.

Re: Sharing MS Acess DB on multiple computers

Posted: Sat Nov 22, 2008 4:53 am
by Layzie Bone
That's what I was reading up on, and i wasn't sure about that, but it might be the solution.

Re: Sharing MS Acess DB on multiple computers

Posted: Sat Nov 22, 2008 4:35 pm
by nesman
Registration is not needed. :) To increase their rank on Google, they show Google the answer. If you come from Google, they show you the answer too.

http://www.google.com/search?q=Using+pr ... r+accounts

Hit the page from there and scroll all the way to the bottom, past the ads and everything. It's formatted to look like footer style fine print, but it's the answer.

Re: Sharing MS Acess DB on multiple computers

Posted: Sat Nov 22, 2008 10:05 pm
by Layzie Bone
Those pages were very useful, only thing I had some trouble getting it to link the tables back to the BE....

Re: Sharing MS Acess DB on multiple computers

Posted: Thu Dec 04, 2008 11:13 pm
by Layzie Bone
Ok here is how you do it.


Basically understand that a database is more than a pile of "stuff" there are two main parts to a datebase, you have the software portion or the "Back end" or known as BE, and the data portion, the "Front End," FE. You use the "Linked Table Manager" to split the database. What you will need to do is put the backend on all the clients and the front end on the "server" computer, and the theory is that you can have one database open on multiple machines.

A lot of people complain that splitting the database slows everything down significantly, even more so on wireless networks, so this might be an issue for some.

Re: Sharing MS Acess DB on multiple computers

Posted: Wed Dec 10, 2008 8:26 pm
by nesman
Thanks for posting your solution.