[AccessD] Error 3001 - invalid argument - What the . . . . ?

Susan Harkins ssharkins at gmail.com
Fri Jun 20 15:08:36 CDT 2008


Don, can you manually update the table by just running a fixed query? Is 
there anywhere that something's locking the table/database? I think you'd 
get a totally different error if that were the case though, but thought I'd 
throw it out there.

Susan H.


> Thanks, Liz.
>
> Not the table, apparently, unless it's something that wouldn't appear 
> using that test.
>
> New development . . . .
>
> The problem is causing the error ANY time my code uses the .AddNew . . . 
> .Update structure. When I comment out the offending code, the next 
> occurrence of that structure elsewhere in the system's code produces the 
> error again.
>
> Pulling my hair . . . .
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Elizabeth.J.Doering at wellsfargo.com
> Sent: Friday, June 20, 2008 12:29 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . . ?
>
> Because it is on the .update line, browse through the table you are
> updating, looking for nasty corrupt records there. Or, try doing a make
> table query to write your target table into a new temp table.  If you
> have a corrupt record, the make table query will more than likely fail,
> maybe with a helpful message of some kind.
>
> HTH,
>
> Liz
>
>
> Liz Doering
> Systems Engineer
> Technology Information Group
> elizabeth.j.doering at wellsfargo.com
> 612.667.2447 (o)
>
>
>
> This message may contain confidential and/or privileged information. If
> you are not the addressee or authorized to receive this for the
> addressee, you must not use, copy, disclose, or take any action based on
> this message or any information herein. If you have received this
> message in error, please advise the sender immediately by reply e-mail
> and delete this message. Thank you for your cooperation.
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray,
> Don [IT]
> Sent: Friday, June 20, 2008 1:48 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . .
> ?
>
> Hmmm.  I'll check, but don't think so.  If that were the case, wouldn't
> I expect the error to occur at the line where I attempt to assign the
> value, rather than the .Update line?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Friday, June 20, 2008 11:41 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . .
> ?
>
>
> Is there possibly a null being passed?
>
> Mark A. Matte
>
>> From: Donald.A.McGillivray at sprint.com> To:
> accessd at databaseadvisors.com> Date: Fri, 20 Jun 2008 13:28:12 -0500>
> Subject: [AccessD] Error 3001 - invalid argument - What the . . . . ?> >
> Out of the blue, I'm getting the above error (minus the "What the . .
> .?") in a proc that has been running rock solid forever. It's in a block
> of code where I'm using DAO to write a record to a table:> > .AddNew>
> !field1 = SomeValue1> !field2 = SomeValue2> .Update> > Code is puking on
> the .Update line.> > I suspect some sort of corruption, but all my usual
> remedies (decompile/recompile, compact/repair) don't seem to be having
> any effect. This is probably my weakest area of understanding with
> Access, etc., so I'm not even sure I'm using those approaches
> correctly.> > Hoping somebody might be able to suggest a more reeliable
> way to the problem . . . .> > Don McGillivray> > > -- > AccessD mailing
> list> AccessD at databaseadvisors.com>
> http://databaseadvisors.com/mailman/listinfo/accessd> Website: !
> http://www.databaseadvisors.com
> _________________________________________________________________
> The other season of giving begins 6/24/08. Check out the i'm Talkathon.
> http://www.imtalkathon.com?source=TXT_EML_WLH_SeasonOfGiving
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list