sharing Access Database

[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

 

[Kevin3NF]

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

 

[xpnovice]

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

 

[Kevin3NF]

Now wold also be a good time to review/make your backup plan.

Glad it helped...

--
Kevin Hill
President
3NF Consulting

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

 

[Tony Toews]

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.

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