CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 ASP error? Im new help would be cool...

Print topic Send  topic

Author Message
snowboardr
Posted: 01/20/2002, 9:45 AM

Operation must use an updateable query. (Microsoft JET Database Engine)

What does this mean? I set it up in the database so it could ReadWrite..I have had this problem for a while now..
Brent
Posted: 01/20/2002, 10:37 AM

You didn't say where this error occurs. It's like telling a doctor,
"I've got this pain, can you fix it?" and you don't tell the doctor where
the pain is or when it occurs. :)

I suspect your SQL statement is causing the problem. There are 2 types of
queries, updateable where you can modify the rows that are returned, and
non-updateable which means the result set is readonly.

Non-updateable queries are usually caused when the SQL statement is retrieving
columns from 2 or more tables, as in a View. You are probably using a View
on an updateable form. You should be using a table.

If you want an updateable Select statement that has data from another table,
then you need to base the Select on only 1 table and then lookup the data
from the secondary table.

I hope this helps. And "take two aspirin and call me in the morning". :)
Nicole
Posted: 01/21/2002, 1:51 AM

The error you are getting has to do with permissions on your server. Refer to the following articles:

http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
Nicole
Posted: 01/21/2002, 1:51 AM

The error you are getting has to do with permissions on your server. Refer to the following articles:

http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.