Re: Error 3146 - ODBC Call failed
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 30 Dec 2008 09:00:19 -0800
Message-ID: <1230656418.94005@bubbleator.drizzle.com>
Date: Tue, 30 Dec 2008 09:00:19 -0800
Message-ID: <1230656418.94005@bubbleator.drizzle.com>
Niranjan wrote:
> 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?
SQL Server is not an Oracle product so we can not help you with your current issue using your existing RDBMS. But if you were to move to Oracle with a real front-end such as HTML_DB, a substantial improvement by almost any measure, the issue would not exist.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Dec 30 2008 - 11:00:19 CST