J
Joe
How can I make a single user access database multiuser?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Access is already multi-user enabled. To take advantage of it:
1. On each person's computer, check the setting is "Shared" under:
Tools | Options | Advanced | Default Open Mode.
2. Split your database into back end (table only) and front end (all other
object, and linked tables). There is a built-in splitter under:
Tools | Database Utilities | Database Splitter
More info:
http://members.iinet.net.au/~allenbrowne/ser-01.html
3. Put the back end in a shared folder that everyone has write-access to.
Put a copy of the front end on each person's workstation.
The default record-locking is optimistic, and is the best approach for most
people. It would be good to train your users as to what the write-conflict
means, but most users never see it.
1. On each person's computer, check the setting is "Shared" under:
Tools | Options | Advanced | Default Open Mode.
2. Split your database into back end (table only) and front end (all other
object, and linked tables). There is a built-in splitter under:
Tools | Database Utilities | Database Splitter
More info:
http://members.iinet.net.au/~allenbrowne/ser-01.html
3. Put the back end in a shared folder that everyone has write-access to.
Put a copy of the front end on each person's workstation.
The default record-locking is optimistic, and is the best approach for most
people. It would be good to train your users as to what the write-conflict
means, but most users never see it.
J
Joe
Thanks Allen.
I appreciate the help.
I appreciate the help.
Allen Browne said:Access is already multi-user enabled. To take advantage of it:
1. On each person's computer, check the setting is "Shared" under:
Tools | Options | Advanced | Default Open Mode.
2. Split your database into back end (table only) and front end (all other
object, and linked tables). There is a built-in splitter under:
Tools | Database Utilities | Database Splitter
More info:
http://members.iinet.net.au/~allenbrowne/ser-01.html
3. Put the back end in a shared folder that everyone has write-access to.
Put a copy of the front end on each person's workstation.
The default record-locking is optimistic, and is the best approach for most
people. It would be good to train your users as to what the write-conflict
means, but most users never see it.