Database

 Users          ContactInfo
_______________              ___________________
|UserID        |             |Email            |      
_______________              ___________________
|Email         |             |Phone            |      
_______________              ___________________
|FirstName     |             |Address          |        
_______________              ___________________
|LastName      |             |City             |    
_______________              ___________________
|UserName      |             |State            |
_______________              ___________________
|Password      |             |Zip              |
_______________              ___________________

cmd1.CommandText = "GRANT ALL PRIVILEGES ON test .* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;"<br />
cmd1.ExecuteNonQuery()<br />
<br />
cmd1.CommandText = "flush privileges;"<br />
cmd1.ExecuteNonQuery()<br />

using (OdbcConnection cnn = new OdbcConnection("Dsn=LclPMedicHist;"))
{
    using (OdbcCommand cmd = new OdbcCommand (strProcName, cnn))
    {
        cmd.CommandType = CommandType.StoredProcedure;
        OdbcParameter prm;

        prm = new OdbcParameter("szName", OdbcType.NText, 50);
        prm.Value = Name;
        cmd.Parameters.Add(prm);

        ....

        cnn.Open();
        cmd.ExecuteNonQuery();
    }
}

An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in System.Data.dll

Additional information: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Invalid SQL 
statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.