How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017
What is a MultiSingle document.For Multisingle document interface, please refer to the MSDI with little change to the class name CviewFrame -> CMSDIViewFrame etc..
Multisingle document with DAO Access.This sample shows a MSDI sample application to open an MS-ACCESS Database as an only one document. If you change to another Database, the actual database is closed with all views (like MS-ACCESS).
The document contains the Database object and the recordset objects. Only one recordset per table is opened. If two views open the same recordset, the recordset is shared between views. An open count is updated to see if the recordset must be closed (Opencount == 0 on close).
This sample works with the sampdata.mdb database only (from DAOVIEW MFC sample). For most TRUE applications, the tables are fixed and a generic table browser is not ideal (like DAOVIEW).
The sample is not a whole application. Only specifics problem are resolved.
Of interest in this sample.
- MSDI Sample Application likes MS-ACCESS.
- The Save as command saves really the whole database in another file.
- Structures and functions to create tables with index, not only to read existing tables.
- List view to display table.
- Print preview for list view with Header, footer and margins.
- Fit to page list view printing or splitting on multi page.
- Copy to for list view in the Clipboard.
- Extract and display bitmap from ClongBinary as a CDaoBitmap class.
Future.If you have some questions or if you have significant generic add on, please contact me.