CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Operation must use an updateable query

Print topic Send  topic

Author Message
Peter
Posted: 09/29/2002, 7:07 AM

Hi,

I'm using your sample application "bugtrack" with MS-ACCESS 2000

When i try to update or to insert one row in any table (like a bug or an employee), i get the followed error message :
Operation must use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)

Besides, i caught the generated query and i executed it directly in ACCESS.
it works fine

Can u help ?

thanks
Eladesor
Posted: 09/29/2002, 7:53 AM

If you do a search on this forum / the help files and the newsgroup you’ll find loads of solutions.

Regards
Eladesor
Nicole
Posted: 10/02/2002, 1:54 AM

Peter,
The error you are getting has to do with permissions on your server. Please refer to the following articles:
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

XP's folder properties are quite a bit different. Here is a MS KB article
with screen shots on how to access the permissions in XP.
http://www.microsoft.com/windowsxp/pro/using/itpro/managing/filesharing.asp
jgmoreira
Posted: 10/03/2002, 12:41 PM

Try this: with the right button of the mouse, check your database file — (*).mdb — "properties". You have to give permission to the user of the web site to change the recordsets in the table.

   


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.