DataBase - How to update a split database

Hi,

My company has a database which I recently split. The database is used
by about 10 people. I wish to be able to add new forms and tables to
the database now and again. The idea I have now is to have the front
and backend to the database on the server and then a shortcut to the
frontend on each user desktop. How should I then go about updating the
front end or backend? Will I need to get everyone out of the db when I
do so?

Also, would replication be of any use in my circumstances? What would
the benefits be?

Thanks for your help,

Barry.

If you have a shared FE then yes you will need to kick everyone out to update the FE
on the server.

However you really want to put the FE on each machine or place in a user specific
directory on the server.   This will help avoid some weird error messages when users
are changing the same forms record source, filters and such as well as corruptions.
It is also much easier to implement a new version of the database with changed
queries, forms, reports and VBA code.

I specifically created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next time someone
went to run the app that it would pull in the latest version.  For more info on the
errors or the Auto FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
to date.

In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
a directory named after the user on a server.  Given a choice put the FE on the
Citrix server to reduce network traffic and to avoid having to load objects over the
network which can be somewhat sluggish.


No.  Replication is designed only for tables.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/