I want to use drupal on an intranet site but have no access to sql.
is there a way to run drupal using ms access and not sql?
No. There's no database layer for that, and I don't think there will ever be one.
How can one have "no access to SQL" when MySQL Community Server and MariaDB (which is sort of compatible) are freely downloadable, for Windows as well?
Drupal is a registered trademark of Dries Buytaert.