I have just had encouragement from the owner to calm things down in here a little. We have a new member who has possibly come in and ruffled some feathers. To them (JSPeta) I would just say please be aware of what you say and give some consideration to how it may be perceived. Enough on that.
To those others, myself included, let's remember that JSPeta is new here and possibly much of what they've said is a defensive reaction to the responses that were triggered, but clearly unexpected. A step back should help. I know that all of us here are old enough (and ugly enough) not to be too sensitive about what others say about us. If ordinary members were involved it might be different but all here can be considered to have skins of rhino.
JSPeta:
I don't know your background, mine is working with MS Access since 1998 and I'm a DBA for SQL Server since 2000.
Welcome to Bytes.com. As a new member here let me advise that a click on any member's icon/ID will take you to their profile & bio. You can find out about me there, as well as IslaDogs & TwinnyFo if you choose.
JSPeta:
My solutions fixes this problem.
(Your table requires a primary key in order to delete a row)
Unfortunately that is not the case. I'm not sure you paid a great deal of attention to earlier posts that explained this so I will post a picture where I created a brand new database, a table with a single field without any PK, and then proceeded to delete one of the records from that table with a simple delete query. This is something you can try for yourself very easily.


As moderators & experts here at Bytes.com we care deeply that we don't allow misinformation to be reflected in the solutions we provide. I'm confident you posted with every good will. I imagine you also have a great deal of experience using Access & SQL Server. In this case though, you were mistaken. I would suggest you accept that just as I've had to once or twice. I certainly hate it when it happens but there's no doubt I've been pulled up by other experts when I've got something wrong. I do what I can to keep that to a minimum ;-)
Perhaps if you continue to post you can show that as being a simple abberation and that you still have a lot to offer.