Dan Waters
dwaters at usinternet.com
Fri Jun 20 13:54:31 CDT 2008
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