sharing Access Database

  • Thread starter Thread starter xpnovice
  • Start date Start date
X

xpnovice

Until now I have run an Access XP db on a stand-alone PC with a Switchboard
setup through which I access all my necessary forms, reports etc.

I have recently installed a small (3 PC) office network and want to share
the db with the two other users.

Question is, providing I set the record locking properties as required, can
I simply place my db on a shared drive and create a shortcut to the
Switchboard on each users desktop for them to access the db?

Thanks
 
For a multi-user setup you really should split the database into two pieces.
One database containing the tables only (back-end), and another for the
forms, reports, queries, etc. (front-end). The FE will have links to the
tables in theBE, and a copy of the FE should be on each user's local drive.

There is a wizard for this at Tools>>Database Utilities>>Database Splitter
that will walk you through it.

Hope this helps,


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Thanks,

Simply really, I thought splitting the db to Fe and Be sounded a bit
technical, but the wizard did it all as you said it would, and it works just
fine.

Thanks again for your help.

John
 
xpnovice said:
Simply really, I thought splitting the db to Fe and Be sounded a bit
technical, but the wizard did it all as you said it would, and it works just
fine.
Click to expand...

When you have some performance problems see the Access Performance FAQ
at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top