MS Access Error

[Richard]

I'm getting an error from my .NET application that
says "Operation must use an updatable query" when I am
trying to write data to an Access table.

Any Ideas?

If I cut and paste the SQL from the application into an
access query, it works.

Thanks.

[Mary Chipman]

So how are you executing the query from your .NET app? Nobody's going
to be able to help unless you post the code.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Fri, 10 Oct 2003 14:09:32 -0700, "Richard" <re******@broward.org>
wrote:

I'm getting an error from my .NET application that
says "Operation must use an updatable query" when I am
trying to write data to an Access table.

Any Ideas?

If I cut and paste the SQL from the application into an
access query, it works.

Thanks.

[Mary Chipman]

So how are you executing the query from your .NET app? Nobody's going
to be able to help unless you post the code.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Fri, 10 Oct 2003 14:09:32 -0700, "Richard" <re******@broward.org>
wrote:

I'm getting an error from my .NET application that
says "Operation must use an updatable query" when I am
trying to write data to an Access table.

Any Ideas?

If I cut and paste the SQL from the application into an
access query, it works.

Thanks.

[Tian Min Huang]

Hello Richard,

Thanks for your post. As I understand, you create a .NET application which
fails to update an Access table with the error "Operation must use an
updatable query". Please correct me if there is any misunderstanding. Now
I'd like to share the following information with you:

1. Please make sure that you have enough rights to access the .MDB file:

1) Right click on the directory that contains the .MDB file.

2) Goto Security tab.

3) Click the Add button.

4) Give FULL CONTROL to EVERYONE.

5) Check whether or not the problem still exists.

2. Does your query contain any ODBC link tables to a SQL table without
unique index? If so, based on my experience, this will cause such error.
You will have to add a unique index to the linked SQL table.

3. In addition, I suggest you to update to Microsoft Jet 4.0 Service Pack 7.
ACC2002: The Updated Version of Microsoft Jet 4.0 Is Available in the
Download Center
http://support.microsoft.com/?KBID=282010

4. If the problem persists, would you please tell me what's the type of
your application, ASP .NET, Windows Form or Console? Is it possible for you
to post some code snippet which causes the error?

I look forward to your response.

Have a nice day!

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.