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!

RunSQL doesn't delete

Status
Not open for further replies.
Sen7inel

Sen7inel

IS-IT--Management
Feb 14, 2001
90
FI
What's wrong with this:

DoCmd.RunSQL("DELETE * FROM tbl_Ctr WHERE (Status = 99)")

Gives me the "problem accessing OLE method" error.
 
Sort by date Sort by votes
Hi, the syntax for DoCmd.RunSQL is
DoCmd.RunSQL sqlstatement[, usetransaction]
so try writing your statement as:
DoCmd.RunSQL "DELETE * FROM tbl_Ctr WHERE Status = 99;"





 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
506
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
526
serino
serino
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
654
MDGarcia
MDGarcia
BTilson
  • Locked
  • Question
Virtually Identical Select Queries - One Works, Other Doesn't?
Replies
2
Views
191
combo
combo
rudolfelizabeth
  • Locked
  • Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
220
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top