McGillivray, Don [IT]
Donald.A.McGillivray at sprint.com
Fri Jun 20 14:10:08 CDT 2008
Thanks, Dan. My field names are prefixed with a table identifier, so keyword confusion is not an issue in this case. When tried and true procs start to fail like this, I always smell a corruption issue, but I'm not so good at tracing and repairing them. Looking for all ideas along those lines, or any others that might help me to ID and resolve the issue. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, June 20, 2008 11:55 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . . ? Be sure that field1 and field2 are not actually Key words. Example: I had a INSERT in access where one of the fields was called 'Note', which is a Key word. It worked for a long time, then failed and kept failing. I'm guessing that something in Windows or Access was updated to cause the sudden failure. Dan -----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:28 PM To: Access Developers discussion and problem solving 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com