如何使用带有Microsoft Access的JDBC执行Microsoft Jet 4.0 SQL命令 [英] How to execute Microsoft Jet 4.0 SQL commands with JDBC with Microsoft Access

问题描述

我有Access DB(mdb文件)，可以使用Java程序连接到该数据库. Access DB的用户级安全性已启用.我正在尝试在用户级安全性(即MDW文件)中添加新用户. 我认为可以通过执行SQL语句= Microsoft Jet 4.0 SQL命令="CREATE USER Boyd password"

I have Access DB ( mdb file) to which I can connect using my java program. User level security for the Access DB is on. I am trying to add new user in the User level security i.e. MDW file. I think this can be done by executing SQL statement = Microsoft Jet 4.0 SQL commands = "CREATE USER Boyd password"

但是当我执行它时，它给我以下错误:

but when i execute it with, it give me error which is as follows:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

有人可以帮助我吗? 预先感谢.

Anyone can help me? Thanks in Advance.

推荐答案

以下代码对我有用:

import java.sql.*;

public class JDBCQuery {
    public static void main( String args[] )
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection(
                    "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};" + 
                    "Dbq=C:\\Users\\Public\\uls\\ulsTest.mdb;" +
                    "SystemDB=C:\\Users\\Public\\uls\\Security.mdw;" +
                    "Uid=Gord;" +
                    "Pwd=obfuscated;" +
                    "ExtendedAnsiSQL=1;");
            Statement s = conn.createStatement();
            s.execute("CREATE USER Tim pwd");
            System.out.println("User 'Tim' created.");
            s.execute("DROP USER Tim");
            System.out.println("User 'Tim' dropped.");
            s.close();
            conn.close();
        }
        catch( Exception e ) {
            e.printStackTrace();
        }
    }
}

这篇关于如何使用带有Microsoft Access的JDBC执行Microsoft Jet 4.0 SQL命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！