This topic is locked

Problem with inserting operation

11/20/2005 10:46:18 AM
ASPRunner.NET General questions
P
pwauthier author

Hello,

I use ASPrunner.net for basic tasks ...

And today, wiith an Access database I a mnot able to insert new records in table with three text fields (no index and no auto-number) !

The error message is :

"The operation must use a query which must be updated".

Could you tell me how to solve this bug

Eugene 11/21/2005

This is permissions error. To fix that, you need to give change permission to MACHINENAME\ASPNET account to the directory where database is located. To do that ,you need to:

  • Right-click on the folder where the database is located
  • Go to Properties
  • Go to Security
  • Add user named MACHINENAME\ASPNET (if don't exists)
  • Assign CHANGE Permission for user MACHINENAME\ASPNET
  • Click OK
    For Windows XP users only:
    If permission tab is not enabled or missing or sharing tab does not allow to grant the permission, you need to do the following:
  • Go to the folder where the database is located
  • Go to Tools->Folder Options->View and uncheck Use simple file sharing (recommended) (last option in the list)
  • Click OK
  • Now you can right-click on the folder where the database is located
  • Go to Properties
  • Go to Security
  • Add user named MACHINENAME\ASPNET (if don't exists)
  • Assign change Permissions for user MACHINENAME\ASPNET
  • Click OK

500389 11/21/2005

Hello,

I use ASPrunner.net for basic tasks ...

And today, wiith an Access database I a mnot able to insert new records in table with three text fields (no index and no auto-number) !

The error message is :

"The operation must use a query which must be updated".

Could you tell me how to solve this bug


Thank you , Eugene,

I modified the permission properties on the directory ( Add ASPNet account ) and I am able to add new records...

But When I want to edit one, I got an error message : Syntax Error in the UPDATE instruction (Erreur de syntaxe dans l'instruction UPDATE.)

Do you have a solution ?
Best regards,

Philippe

Eugene 11/22/2005

Please zip and send on [email=support@xlinesoft.com]support@xlinesoft.com[/email] your project file along with your database creation script or database dump for investigation.