Welcome to SPN

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

Sign Up Now!

Re: Db Corruption

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

Tags:
  1. Daniel

    Daniel
    Expand Collapse
    Guest

    Tony,

    I tried some of your other suggestions but nothing seems to have worked thus
    far. I am interested in implementing what you suggested (see posting below)
    but am unfamiliar with it. Could you explain some more or if you have a
    sample code I could use it would be appreciated!


    Thank you,

    Daniel




    "Tony Toews" wrote:

    > Daniel <Daniel@discussions.microsoft.com> wrote:
    >
    > >I this specific case I know that the network is slow...

    >
    > Ouch. Especially if there is a real slowdown at intermittent
    > intervals. Access is the proverbial canary in a gold mine.
    >
    > >Would any of the
    > >advanced option improve stability (I know they exist but do not know what
    > >they actually do so I've never messed with them)?
    > >
    > >OLE/DDE Timeout
    > >ODBC refresh interval

    >
    > The above no is they have nothing to do with a Jet database.
    >
    > >Refresh interval
    > >Number of update retries
    > >Update retry interval

    >
    > These maybe. Kinda doubtful but worth experimenting I guess.
    >
    > One thing to do would be to setup some logic behind the startup form
    > and a hidden form to log the entries and exits of PCs from the backend
    > MDB. Any for which you don't see exists means that they exited
    > abnormally. If only one PC shows up there then you can assume that
    > PC is the problem. If multiple PCs you might be able to figure out
    > if they are on one particular switch.
    >
    > BTW is there a WAN of some sort involved? Multiple buildings? Or are
    > all the PCs n one building.
    >
    > 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
    >
     
  2. Loading...

    Similar Threads Forum Date
    India Corruption rate in India is double of global average Breaking News Jul 9, 2013
    Partition Corruption in the Punjab... History of Sikhism Mar 24, 2013
    Bant Singh - A real anti-corruption hero Inspirational Stories Feb 27, 2013
    India US report slams India on corruption, social violence Breaking News May 25, 2012
    India Panthic Morcha harps on transparency, corruption Breaking News Aug 22, 2011

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Daniel <Daniel@discussions.microsoft.com> wrote:

    >> One thing to do would be to setup some logic behind the startup form
    >> and a hidden form to log the entries and exits of PCs from the backend
    >> MDB. Any for which you don't see exists means that they exited
    >> abnormally. If only one PC shows up there then you can assume that
    >> PC is the problem. If multiple PCs you might be able to figure out
    >> if they are on one particular switch.


    >I tried some of your other suggestions but nothing seems to have worked thus
    >far. I am interested in implementing what you suggested (see posting below)
    >but am unfamiliar with it. Could you explain some more or if you have a
    >sample code I could use it would be appreciated!


    You have an activity table with the computer name and network account.
    You create a form which is opened on startup somehow but hidden.. In
    it's OnOpen event you create a record in the activity table and record
    the autonumber ID in a field in the form. Then in that forms On Close
    event you update that record as closed. That even will only get
    triggered when you close the database.

    Thus any entries in the table which haven't been closed mean that
    computer somehow disconnected abnormally.

    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
     

Share This Page