Error 3073-Operation must use an updateable query

[MisterC]

Hi folks,
Sorry for the repost. I'm using VB6 to update a dBase IV dbf file something like this:

  dim db       as Dao.Database
  dim strSQL   as string
  Set db = OpenDatabase("C:\PData", False, False, "dBase IV;")
  strSQL = "UPDATE FlagTable Set ACD = 'D' WHERE PID IN (10200, 12400, 12600)"
  db.Execute strSQL

When the code runs, I get error 3073-Operation must use an updateable query. Does anyone have any suggestions?
Thanks!

 

[1oldfoxman]

I'm not familiar with what you're doing with VB6, but if you're expecting dBaseIV itself to execute a SQL statement, it won't. Not that I've ever been aware of anyway. (It HAS been a long time since I touched dBaseIV.....) Does something in VB convert your SQL to dBase commands to act on the .dbf file?

 

[1oldfoxman]

I forgot to say - you probably should post this question in the VB forum if you haven't already.

 

[MisterC]

Yes, the application is executing (trying to at least) an SQL UPDATE query on the dbf file through DAO. I usually have no problems with this but for some reason...

I've posted this same question in VB, VB Databases, and in a last ditch effort-here. No one seems to have an answer for me.

Anyway, thanks for taking the time to reply.

 

[MiggyD]

I seldom use VB6; but have you reviewed any of your "other" programs to see if the setup is correct for DB4?


Things to consider:

Are your "other" apps using Jet2.x(ADO) or 3.x(DAO)?

For some reason, I think I remember reading somewhere that the single quotes should ('D') be double quotes ("D&quot...but I could be wrong.


These are the only things that are popping in right now. Hope something here helps.
--MiggyD