DELETE IN External DB

[Guest]

I think you have the position correct, just not the syntax.

DeleteSql = "DELETE * FROM tblPay IN 'C:\RED\Reddy.mdb' " _
& "WHERE tblPay.PayNameID=" _
& [Forms]![frmBSCouponNames]![TxtID]
DoCmd.RunSQL (DeleteSql)

You could also use:
Currentdb.execute DeleteSQL, dbfailonerror

This latter method does not provide warnings indicating the number of
records about to be deleted though.

HTH
Dale

 

[DS]

Kinda like Suspicious SQL but this is DELETE...

DeleteSql = "DELETE * FROM tblPay IN '" & C:\RED\Reddy.mdb & "' " & _
"WHERE (((tblPay.PayNameID)=[Forms]![frmBSCouponNames]![TxtID]));"
DoCmd.RunSQL (DeleteSql)

Where does the IN part go?
Thanks
DS

 

[DS]

Kinda like Suspicious SQL but this is DELETE...

DeleteSql = "DELETE * FROM tblPay IN '" & C:\RED\Reddy.mdb & "' " & _
"WHERE (((tblPay.PayNameID)=[Forms]![frmBSCouponNames]![TxtID]));"
DoCmd.RunSQL (DeleteSql)

Where does the IN part go?
Thanks
DS

Got It.
DeleteSql = "DELETE * FROM table1 IN '" & REDACT() & "' " & _
"WHERE (((table1.IDNumber)=1));"
DoCmd.RunSQL (DeleteSql)
DS

 

[DS]

I think you have the position correct, just not the syntax.

DeleteSql = "DELETE * FROM tblPay IN 'C:\RED\Reddy.mdb' " _
& "WHERE tblPay.PayNameID=" _
& [Forms]![frmBSCouponNames]![TxtID]
DoCmd.RunSQL (DeleteSql)

You could also use:
Currentdb.execute DeleteSQL, dbfailonerror

This latter method does not provide warnings indicating the number of
records about to be deleted though.

HTH
Dale

Thanks,Dale
dbFailonerror means what?
DS

 

[Guest]

dbFailOnError causes Access to throw an error when it encounters an error in
the Execute method. Without this parameter, Access will drive on without
generating an error, so you think it did the deletion, when in actuallity, it
didn't.

HTH

--
Email address is not valid.
Please reply to newsgroup only.

I think you have the position correct, just not the syntax.

DeleteSql = "DELETE * FROM tblPay IN 'C:\RED\Reddy.mdb' " _
& "WHERE tblPay.PayNameID=" _
& [Forms]![frmBSCouponNames]![TxtID]
DoCmd.RunSQL (DeleteSql)

You could also use:
Currentdb.execute DeleteSQL, dbfailonerror

This latter method does not provide warnings indicating the number of
records about to be deleted though.

HTH
Dale

Thanks,Dale
dbFailonerror means what?
DS