Connecting Tech Pros Worldwide Forums | Help | Site Map

Sharing Access

Robin Lumley
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

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:
http://allenbrowne.com/ser-01.html

--
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@btinternet.com> wrote in message
news:c5rsev$sdm$1@hercules.btinternet.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]


Closed Thread