Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Error: Operation must use an updateable query

Status
Not open for further replies.
jsteff

jsteff

Technical User
May 22, 2003
109
US
Running Excel 2000 with related Excel ODBC driver.

When I try to updte with my external tool, I get the error message:
Operation must use an updateable query

any ideas?

Thanks.

 
Sort by date Sort by votes
What tool are you using - msquery, perhaps? If so, the default query is read-only. you need to change the query to allow updates by making it an updateable query. check for a query menu or toolbar button.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
156
Antonius222
Antonius222
Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
506
Rudraya
Rudraya
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
493
dcern
dcern
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
799
k5tm
k5tm
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
459
acoronel
acoronel

Part and Inventory Search

Sponsor

Back
Top