Re: Error 3146 - ODBC Call failed
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 30 Dec 2008 08:03:55 GMT
Message-ID: <1230624234.11586@proxy.dienste.wien.at>
Date: 30 Dec 2008 08:03:55 GMT
Message-ID: <1230624234.11586@proxy.dienste.wien.at>
Niranjan <nhiras_at_gmail.com> wrote:
> 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?
Easy, just use Oracle instead.
You have come to the right group!
Yours,
Laurenz Albe
Received on Tue Dec 30 2008 - 02:03:55 CST