Multiple users

[Guest]

We have a database, on a network which is used by ~5 users. We all prepare
reports and need access to each others reports. I have been reading about
splitting the database but feel this would not work for us as we would have
different reports on our hard drive that each other would need access to and
so this would be very messy. Or am I misunderstanding this?

At the moment I seem to be able to use the database when someone else is
using it without any problems.

Is it necessary for us to split the database? If so, is there a way around
having a front end on each PC? Are there any other suggestions for the best
way for us to organise our database? Any advice would be gratefully
appreciated. Thanks in advance

 

[Roger Carlson]

Although it is not the recommended practice, you CAN put both the Front-End
and the Back-End on the network and continue to share the Front-End.
Spitting the database, even in this configuration, is preferred over having
tables and application in one database. For one thing, you can modify an
off-line copy of your application (forms, reports, and such) while other
people still use the application and copy it over the old one without losing
data.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L