Excel with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
I have built an Access Database that is "managed" through Excel. I have
Click to expand...
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?
 
Back
Top