I simply have a database with some number of tables which, depending on the client, may or may not be opened in read-only mode.
To this connection I attach another smaller DB which simply have things posted to it on occasion as needed. When the main DB is opened in read-only mode and I try to write to a table in the Attached DB, this obviously fails and reports the read-only notice. How can I attach some DB to a read-only DB so that the attached DB is not read-only? (I could open the other DB and then attach the main one, but that would render the main one NOT read-only, so not viable). In fact, is there any way in which one could see one DB from another without having the same read-only-ness imposed on both?
