Enable admin statements using Microsoft Access ODBC Driver

Connection string

This Microsoft Access ODBC Driver connection string can be used for connections to Access 97, Access 2000, Access 2002 and Access 2003.

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)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ExtendedAnsiSQL
=1;