Excel with Access
 

I have built an Access Database that is "managed" through Excel. I have code that updates/refreshes data in the database. One last step I can't figure out is if there is code I can write where I can delete 1 record in a table. I can't link the table to Excel, because I need to maintain a primary key. I have code that updates and creates, but I can't figure out how to delete. Can anyone help me out?

Excel with Access
 

Shin

If you're using ADO, you can use the Delete method of the Recordset object.
Check it out in help.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Shin" wrote in message
...
I have built an Access Database that is "managed" through Excel. I have
code that updates/refreshes data in the database. One last step I can't
figure out is if there is code I can write where I can delete 1 record in a
table. I can't link the table to Excel, because I need to maintain a
primary key. I have code that updates and creates, but I can't figure out
how to delete. Can anyone help me out?