Error 3146 - ODBC Call failed
From: Niranjan <nhiras_at_gmail.com>
Date: Mon, 29 Dec 2008 16:30:58 -0800 (PST)
Message-ID: <ed86981c-87c9-4cdb-8b50-0bd4dac58087@z27g2000prd.googlegroups.com>
Date: Mon, 29 Dec 2008 16:30:58 -0800 (PST)
Message-ID: <ed86981c-87c9-4cdb-8b50-0bd4dac58087@z27g2000prd.googlegroups.com>
Hi everyone
We just upsized to SQL server (Access 2003 front end). I am running
into error 3146 on a particular table. Part of my code, I have a
simple delete SQL statement and I am getting an error on this
statement.
CurrentDb.Execute "Delete * from [Raw Import Table];", dbSeeChanges
Raw Import Table has a PK (ID - Autonumber).
Does anyone know how to fix it? Received on Mon Dec 29 2008 - 18:30:58 CST