Welcome to SPN

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

Sign Up Now!

What causes #Error to display in Table displays?

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

  1. HarryJ

    HarryJ
    Expand Collapse
    Guest

    I have an Access 2000 application that contains 35 tables 80+ queries and 130
    forms and reports. Everything seems to work fine except periodically 1 table
    gets a record added that has the litteral #Error in each field of the 15
    fields in only 1 or two records (the table contains 15000 records) and gets
    added to each day. This problem does not occur every day.
    What causes these records to be created without any indication and how can I
    find out what is causing this problem? Users report that they either do not
    see reports or cannot see forms that use this table but they don't know what
    table is involved or what action might have caused the problem.
    Any help will be appreciated.
     
  2. Loading...

    Similar Threads Forum Date
    Christianity Google's Cesar Chavez 'doodle' Causes a Stir on Easter Sunday Interfaith Dialogues Apr 1, 2013
    SciTech Too Much Tea Causes Unusual Bone Disease Breaking News Mar 22, 2013
    Supernatural Russian meteor causes blast; hundreds injured Breaking News Feb 15, 2013
    Opinion Violence Significantly Alters Children's DNA, Causes Premature Aging Breaking News Apr 25, 2012
    Christianity Pope Explains Causes of British Riots Interfaith Dialogues Sep 11, 2011

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    HarryJ wrote:
    > I have an Access 2000 application that contains 35 tables 80+ queries
    > and 130 forms and reports. Everything seems to work fine except
    > periodically 1 table gets a record added that has the litteral #Error
    > in each field of the 15 fields in only 1 or two records (the table
    > contains 15000 records) and gets added to each day. This problem does
    > not occur every day.
    > What causes these records to be created without any indication and
    > how can I find out what is causing this problem? Users report that
    > they either do not see reports or cannot see forms that use this
    > table but they don't know what table is involved or what action might
    > have caused the problem.
    > Any help will be appreciated.


    This is a symptom of file corruption. If you're lucky, a compact/repair will
    correct it.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page