Hi,

https://www.openstreetmap.org/way/130453472

I'm wondering why this road is marked access=no.

Such a tag is more appropriate to the likes of a firing range or sinkhole.

If something is out of bounds to the general public, it can be marked access=private.