Dynamic User Manipulation

[Rahul]

Does Access support Dynamic User Manipulation.
What I mean is that can I send CREATE USER or MODIFY USER commands to the DB
from VB.NET or any other language. e.g

Query="CREATE USER user1 pass1 id1;"
Dim command as new OleDbCommand(con,Query)
command.ExecuteNonQuery()

Will the above code run successfully????

Also, I tried to use the SQL Window in Access while creating Queries to
execute the command:

CREATE USER user1 pass1 id1;

But Access did not allowed me to execute it. Why so?????

 

[Arvin Meyer [MVP]]

DDL for CREATE USER is not supported (I'm pretty sure) but there is a
CreateUser method in DAO, which you can use from VBA code.