Honestly, I don't think I've seen a posting about Rotenone this whole year....until now. I guess I've missed them. It's a chemical that should never be recommended, and is not readily found on the retail market anymore, I don't believe.

It has been and it is readily available in many places. I have been telling many peole for 10 years now tht Rotenone is not an acceptable organic pesticide only to be told by some that it is, because it is a "natural" pesticide. So is Arsenic.

Rotenone has only limited uses left for home use. Soon to be a restricted-use chemical, not available for home use.

I had heard rumors so emailed the Oregon Dept of Agriculture for facts.

This is, in part, is the response ---

"Back in 2007, the U.S. Environmental Protection Agency and the companies that sell products containing rotenone made the decision to cancel all livestock, residential/homeowner, domestic pet, and all other uses of rotenone except for "fish-kill" uses. This decision has been gradually implemented since that time."

And more --
"In Oregon, for products containing rotenone, as of this date: We still have two (2) home/garden products registered for use on fruits/vegetables, one (1) product registered for use on pets (dog/cat/rabbit), and one (1) product registered for commercial agricultural use on fruit/vegetable crops. There is a final cancellation action pending at EPA that proposes that all of these products will no longer be allowed to be SOLD after May 2011."

If Rotenone is not good to use what can be used to kill beetles in the flower garden without killing bees?

Which beetles?
Are they pests, beneficials, or innocuous?
In addition to rotenone other "natural" pesticides, such as pyrethrins, spinosad, ryania, and some others are just as broad spectrum as the synthetic poisons. Others, Neem oil and the bacteriums, are less toxic although some claim they are non toxic. However, if a substance kills something it is not non toxic.
Identify what you have and decide whether it is a good or bad bug and if it needs to be poisoned and then find the least toxic (to you) method of control.

Maybe my question wasn't clear so I will state it more precisely.

I want Japanese, Oriental and Asiatic beetles to die when they are on and attack plants in a flower garden. Is there an insecticide that will do that without killing bees?

Nope. The best option is a pyrethrum based insecticide used with due care so you do not spray when bees are active.

You can buy a Japanese beetle trap. They worked really well for me when I lived in Pa.

Japanese Beetle traps actually attract the beetles to your yard and garden.