Re: how do you delete an invalid argument in access

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 11:12:42 +0800

Hi Deb

This problem is the result of a data corruption, and is not caused by
something you did.

To rebuild your database, see the article:
    Recovering from Corruption
at:
    http://members.iinet.net.au/~allenbrowne/ser-47.html
particularly the 2nd symptom:
    Symptom: Some table rows show #Deleted

As the article explains, you can rescue your data into a rebuilt table,
provided you do not refer to the problem row. For example, if the problem
row is autonumber 88, you would rescue the data with a query that has
criteria of:
    <= 87 OR >= 89 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Deb" <Deb@discussions.microsoft.com> wrote in message
news:EE31E61C-4587-429E-92AE-EFC48218991C@microsoft.com...
> In our table we have 1 line that has #Error all across the line. We have 
> all
> the information above and below but we can't get this line to delete. It
> continues to give us a "invalid argument" and it just keeps popping up and 
> we
> can't do anything in our table. We don't know what happened to cause this.
> Can anyone help us?

Relevant Pages

  • Re: Privileged Instruction exception in Release build
    ... Did you do a full rebuild after changing the size of any structures ... virtual methods, or making an existing method virtual, or making an ... Possible uninitialised memory problem, leading to data corruption, ... Possible bad message map, leading to stack corruption, leading to bug ...
    (microsoft.public.vc.mfc)
  • Re: Are multiple Entourage database rebuilds a death knell?
    ... It's always a sign that something somewhere is wrong when you must rebuild ... your mail database, so you could say it's "bad", but the problem isn't ... > Does the need to rebuild mean the database is fatally corrupted/ready ... not the symptom. ...
    (microsoft.public.mac.office.entourage)
  • Re: One user cannot receive mail
    ... eseutil to the rescue. ... rebuild and defrag cured the problem. ... Jason ... Prev by Date: ...
    (microsoft.public.windows.server.sbs)