Welcome to SPN

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

Sign Up Now!

I get Invalid Argument message, record reads #Error, what to do?

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

  1. Ben

    Ben
    Expand Collapse
    Guest

    One of the records in an Access database shows #Error in all the fields.
    I get the "Invalid Argument" window message and I can't even delete the
    record. Any suggestions on how to fix this problem.
    Very much appreciated and Thanks in advance
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh rendered invalid in ’84 riots seeks justice (Gulf Times) Breaking News Mar 14, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Calcutta News) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (New Kerala) Breaking News Mar 13, 2008
    Sikh News 23 years later, invalid Sikh seeks justice (Hindustan Times) Breaking News Mar 13, 2008
    1984 1984 anti-Sikh riots: Sajjan Kumar, others conclude final arguments History of Sikhism Feb 5, 2013

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Try TOOLS - Compact and Repair.

    "Ben" wrote:

    > One of the records in an Access database shows #Error in all the fields.
    > I get the "Invalid Argument" window message and I can't even delete the
    > record. Any suggestions on how to fix this problem.
    > Very much appreciated and Thanks in advance
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 20 Jul 2006 12:53:02 -0700, Ben
    <Ben@discussions.microsoft.com> wrote:

    >One of the records in an Access database shows #Error in all the fields.
    >I get the "Invalid Argument" window message and I can't even delete the
    >record. Any suggestions on how to fix this problem.
    >Very much appreciated and Thanks in advance


    Your database is corrupt. You'll almost certainly need to create a new
    ..mdb file; import all the OTHER objectx. Import this table *design
    mode only* - don't import the data, or you'll just corrupt the new
    database!

    Link to this database and then run an Append query to append all
    records *except* this one. It's best to use range criteria on the
    table's primary key to select records before and after (but not
    including) this corrupt record.

    See http://www.granite.ab.ca/access/corruptmdbs.htm for more
    information about corruption in Access databases.

    John W. Vinson[MVP]
     
  5. Ben

    Ben
    Expand Collapse
    Guest

    RE: I get Invalid Argument message, record reads #Error, what to d

    Thanks Karl for your response.
    I tried that already and then I get a different message due to a network
    situation, so that option didn't help as it has in the past.
    Thanks though.
    Ben

    "KARL DEWEY" wrote:

    > Try TOOLS - Compact and Repair.
    >
    > "Ben" wrote:
    >
    > > One of the records in an Access database shows #Error in all the fields.
    > > I get the "Invalid Argument" window message and I can't even delete the
    > > record. Any suggestions on how to fix this problem.
    > > Very much appreciated and Thanks in advance
     
  6. Ben

    Ben
    Expand Collapse
    Guest

    Re: I get Invalid Argument message, record reads #Error, what to d

    Thanks John. I am going to try what you explained in your message.
    I did get some similar suggestions but what they suggested was to export the
    data, your message was more explicit and clear. Thanks.
    Ben

    "John Vinson" wrote:

    > On Thu, 20 Jul 2006 12:53:02 -0700, Ben
    > <Ben@discussions.microsoft.com> wrote:
    >
    > >One of the records in an Access database shows #Error in all the fields.
    > >I get the "Invalid Argument" window message and I can't even delete the
    > >record. Any suggestions on how to fix this problem.
    > >Very much appreciated and Thanks in advance

    >
    > Your database is corrupt. You'll almost certainly need to create a new
    > ..mdb file; import all the OTHER objectx. Import this table *design
    > mode only* - don't import the data, or you'll just corrupt the new
    > database!
    >
    > Link to this database and then run an Append query to append all
    > records *except* this one. It's best to use range criteria on the
    > table's primary key to select records before and after (but not
    > including) this corrupt record.
    >
    > See http://www.granite.ab.ca/access/corruptmdbs.htm for more
    > information about corruption in Access databases.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page