Welcome to SPN

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

Sign Up Now!

Read only back end after syncronising

Discussion in 'Information Technology' started by Charlie, Jul 28, 2006.

  1. Charlie

    Charlie
    Expand Collapse
    Guest

    Hi,

    Each week I syncronise the back end at site 1 with the backend at site 2 -
    this is done overnignt as the VPN connection is very slow.

    This morning the backend at site 2 has come up as read only and nothing can
    be edited. I have checked the database properties to see if the read only is
    check and it is fine. No other users have the back end open and I have no
    icon to show that the backend is open or locked.

    All users have a front end on their PC's and all have the sharing option
    ticked in the advanced tab in Tools-Options.

    We are running Access 2002 / 2003 (dependant on machine)

    Charlie
     
  2. Loading...

    Similar Threads Forum Date
    Does Reading Baani Magically Affect Our Body And Psyche? And Does The Effect Depend On The Bani Read Intellectual Translations by SPNers Apr 30, 2016
    Need to slow down- read till end. Inspirational Stories Aug 16, 2008
    SPN Interfaith Calender is ready thanks to Etinder Ji Announcements Jan 3, 2005
    Literature Has Anyone Read: "The Sikh Religion: Its Gurus, Sacred Writings And Authors" Language, Arts & Culture Oct 22, 2016
    Sikhi Am I Ready To Take Amrit? Sikh Sikhi Sikhism Mar 10, 2016

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Charlie wrote:
    > Hi,
    >
    > Each week I syncronise the back end at site 1 with the backend at
    > site 2 - this is done overnignt as the VPN connection is very slow.
    >
    > This morning the backend at site 2 has come up as read only and
    > nothing can be edited. I have checked the database properties to see
    > if the read only is check and it is fine.


    Have you checked the "File" properties as opposed the the database
    properties. Also how about the directory properties?

    > No other users have the
    > back end open and I have no icon to show that the backend is open or
    > locked.
    >
    > All users have a front end on their PC's and all have the sharing
    > option ticked in the advanced tab in Tools-Options.
    >
    > We are running Access 2002 / 2003 (dependant on machine)
    >
    > Charlie


    --
    Joseph Meehan

    Dia duit
     
  4. Charlie

    Charlie
    Expand Collapse
    Guest

    Yes both of these have been checked and all is as it should be

    Charlie

    "Joseph Meehan" wrote:

    > Charlie wrote:
    > > Hi,
    > >
    > > Each week I syncronise the back end at site 1 with the backend at
    > > site 2 - this is done overnignt as the VPN connection is very slow.
    > >
    > > This morning the backend at site 2 has come up as read only and
    > > nothing can be edited. I have checked the database properties to see
    > > if the read only is check and it is fine.

    >
    > Have you checked the "File" properties as opposed the the database
    > properties. Also how about the directory properties?
    >
    > > No other users have the
    > > back end open and I have no icon to show that the backend is open or
    > > locked.
    > >
    > > All users have a front end on their PC's and all have the sharing
    > > option ticked in the advanced tab in Tools-Options.
    > >
    > > We are running Access 2002 / 2003 (dependant on machine)
    > >
    > > Charlie

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Charlie wrote:
    > Yes both of these have been checked and all is as it should be
    >
    > Charlie
    >
    > "Joseph Meehan" wrote:
    >


    Sorry, but that was the extent of my experience. Hopefully someone else
    will have a suggestion. I seem to recall someone having a like problem and
    one of our regulars had a reference from MS for them.

    --
    Joseph Meehan

    Dia duit
     
  6. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    mdb is a crap database

    learn sql server; use sql server

    don't ever use mdb for even a single record and a single user.

    mdb is passe welcome to the 90s.
     
  7. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    aaron.kempf@gmail.com wrote:
    > mdb is a crap database
    >
    > learn sql server; use sql server
    >
    > don't ever use mdb for even a single record and a single user.
    >
    > mdb is passe welcome to the 90s.


    I am truly sorry you were never able to learn how to use MS Access.

    --
    Joseph Meehan

    Dia duit
     

Share This Page