Sharing Access

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Robin Lumley

    Sharing Access

    Have a peer to peer win98se network, & would like to share Access DB on both
    machines so they can both edit/input & save simultaneously same time what do
    I need to do to allow this ?


  • Allen Browne

    #2
    Re: Sharing Access

    Access is designed to do this, so go ahead and place the file in a folder
    that is shared will full access.

    For best results, split the database into two mdb files. There is a wizard
    to do this for you:
    Tools | Database Utilities | Database Splitter
    For an explanation of how/why, see:
    Describes how and why to split an Access database into two separate files, for upgradability and use over a network.


    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Robin Lumley" <r.lumley@btint ernet.com> wrote in message
    news:c5rsev$sdm $1@hercules.bti nternet.com...[color=blue]
    > Have a peer to peer win98se network, & would like to share Access DB on[/color]
    both[color=blue]
    > machines so they can both edit/input & save simultaneously same time what[/color]
    do[color=blue]
    > I need to do to allow this ?[/color]


    Comment

    Working...