> 1. The present thought is to split the DB leaving the
> front-end in the directory on the server where it
[quoted text clipped - 3 lines]
> keep the front-end on the server and any modifications
> done will be available realtime to several users.
This is not so, if you are using Access 2000 or higher. You must have
exclusive access to the mdb to make design changes.
> Is this
> a practical option or does one have to place a front-end
> on 35 PC's and find a method of updating them all with
> the latest changes made to the front-end from time to
> time?
\
That is the better solution. With that many users, you run an increased
risk of corruption with them all using the same frontend. Give each user a
copy and update when you've finished modifying the frontend and tested it.
Tony Toews has a utility you can use to update the frontends automatically.
See
http://www.granite.ab.ca/access/autofe.htm
> 2. We have full security on the existing DB and wonder
> if there are any negative consequences of splitting the
> DB at this time?
Very glad you asked before proceeding. Don't use the splitter wizard -
you'll end up with a secure frontend, but an unsecured backend. Instead
split it manually to ensure both remain secure - it's easy to do.
Make a copy of your mdb - this will be the backend. Open the backend and
delete all objects except the tables/relationships. Open the frontend and
delete the tables/relationships. Then go to File, Get External Data, Link -
find the backend and link to its tables. If you use Network Neighborhood to
find the backend on the server, the links will use UNC pathnames. When you
copy the frontend to each user, you then won't need to worry if users have
the same drive mappings as you.

Signature
Joan Wild
Microsoft Access MVP