Re: "Operation Must Use An Updatable Query"?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Can you show some code which you are using to try and update the
database with?

--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"cyber0ne" <cyber0ne1@xxxxxxxxx> wrote in message
news:1149263588.528976.268240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm having a bit of trouble adding records to a local .DB file (using a
Paradox connection string). I checked the file permissions, and for
testing purposes set Everyone to Full access. But it seems that I can
add one and only one record to the table, any other attempts to insert
a record generate the error:

"Operation Must Use An Updatable Query"

I can access the table via other means, delete that one record, try
again, same results. Then I close out my application, leave the record
in the table, re-open the application and try again, and it gives the
same error before entering anything (since one and only one record is
already in the table).

Any idea what might be wrong?



.

Relevant Pages

  • Re: "Operation Must Use An Updatable Query"?
    ... Sounds like a Paradox or database issue. ... Paradox connection string). ... I checked the file permissions, ... testing purposes set Everyone to Full access. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: "Operation Must Use An Updatable Query"?
    ... Do you have a primary or unique key defined? ... Paradox connection string). ... I checked the file permissions, ... testing purposes set Everyone to Full access. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Database securing problem
    ... Place it on a Win2k or XP machine and set the file permissions. ... > I'm running a MSDE 1.0 on a windows 98 machine. ... > person with file access can simply copy the database (mdf ...
    (microsoft.public.sqlserver.security)
  • Re: Retreiving the owner of a File
    ... with wrapper upon wrapper of bloated and slow sub-systems. ... How fast do you think it would run with Linux on the same hardware? ... If you're file permissions are so complex you need a database, it probably means you're doing something wrong and anyway, this database would not be updated in real time. ...
    (microsoft.public.vsnet.general)
  • Re: ASP.NET & Access database
    ... There's two types of permissions needed in order to be ... able to access data in a database in an external server: ...
    (microsoft.public.dotnet.framework.aspnet)