To create a
new, empty Microsoft
Access (*.mdb
or *.accdb) database as a data source in your application it is necessary to inform where it
will be created, its name and optionally a password.
It is
accessed through:
Project > Add Layer > From Data Source... > Microsoft Access > 
or
Tools > Data Source Explorer... > Microsoft Access >
To create a empty Microsoft
Access
database named "my_new_ado_db" as data source it is
necessary to inform:
- Server
information
- Provider =Microsoft.Jet.OLEDB.4.0 / Microsoft-ACE.OLEDB.12.0 (for Access 2010 and earlier) / Microsoft-ACE.OLEDB.15.0 (Access 2013 64bit)
- Creation
Information
- New
Database Name = C:/my_new_ado_db.accdb (or .mdb) (or click on
)
- Password = ***** (optional)
- Optionally click on Create OGC metadata tables to create the OGC metadata tables.
- Press Apply.
Note: After
that a new Microsoft Access connector will be available with a title formed by the database name at
Data Source Selector > Microsoft Access interface where the title can be changed using the
Edit option. In this example the connection title would be
C:/my_new_ado_db.accdb.
Note: The "Provider" information change according to Microsoft Office installed.