Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Update BE Split Databases

Discussion in 'Information Technology' started by Larry Kahm, Oct 27, 2005.

  1. Larry Kahm

    Larry Kahm
    Expand Collapse
    Guest

    If you can use a third-party product, take a look at FMS's Total Access
    Admin. http://www.fmsinc.com/products/Admin/index.asp

    This product lets you alert users so that you can make the changes you need
    to the BE.

    There are only a few components to install into your application, with a
    minimum amount of modifications to those components.

    I've recently used it at a client site and their local part-time database
    admin is thrilled with the ablity to find out who is in the database, send
    the notice that it is time to log off, and have the product force users out
    if they left their workstations on overnight.

    Also - and I found this out first-hand - FMS provides really top-notch
    service and technical support!

    Larry Kahm
    Heliotropic Systems, Inc.

    "bondtk" <bondtk@discussions.microsoft.com> wrote in message
    news:D989997A-A656-406A-B27C-FD1494F84B8E@microsoft.com...
    > I've been reading how to split a database into a FE/BE scenario which
    > sounds
    > great! I understand how easy it would be for me to update the front end,
    > let's say, on my local machine then send out the updated version to all
    > users
    > (with the proper links of course). But does anyone have a good idea of
    > how
    > to make changes to the back end of the database without making all users
    > exit
    > out of their front end copy? Let's say I wanted to change or add a field
    > to
    > a table or add a completely new table. Access won't let me update the back
    > end unless all users are "out". I thought about copying the BE and doing
    > the
    > changes, but while I would be updating the BE, the users would be
    > constantly
    > adding new records, which wouldn't be in my working copy if I copy my
    > updated
    > BE over the old one. My first guess is to make sure I have all my tables
    > set
    > up fairly well before deployment. One question/comment about FE changes-I
    > assume that once I do an update on the FE, I could very simply email the
    > new
    > FE to all users (with correct UNC links) and instruct them to save and
    > overwrite the old version.
     
  2. Loading...

    Similar Threads Forum Date
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Update Blogs Oct 16, 2015
    Update Wikipedia Enteries On Sikh Socio-Political Topics Breaking News Jul 19, 2015
    Pacific Oil Slicks Spotted In Search For Missing Malaysia Airlines Plane (Live Updates) Breaking News Mar 8, 2014

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page