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.


Check Solution