Enable admin statements using Microsoft Access accdb ODBC Driver

Connection string

This Microsoft Access accdb ODBC Driver connection string can be used for connections to Access 2007, Access 2010 and Access 2013.

To enable certain programatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;
Uid
=Admin;
Pwd=;ExtendedAnsiSQL=1;