Can I open my Gnucash SQL database with another program, perhaps Microsoft Access?
A qualified yes. To use a PC program like Access (or Open Office’s Database) you’ll need the ODBC driver for whichever database you decided to use. You can of course query the database using the tools that database engine (Sqlite3, MySql, or Postgresql) provides, including embedded sql programming tools.