If this is a Jet 4.0 (Jet OLEDB:Engine Type=5, a.k.a. "Access 2000/2002/2003 format") database then there are two types of "passwords."

One is the simple caveman "database password" for share-level security and the other is a "user password" that varies by user when you are using proper Jet user & group role-based security.

If you are using share-based security then it is merely a matter of supplying that password when you connect. The Connection Property is named "Jet OLEDB:Database Password" and you can set this in the connection string or separately via the Connection.Properties collection.

The same is true for role-based security, but you have two properties "User ID" and "Password" to set.


Once you have a connection opened with sufficient permissions you can add a column/field to the table either via ADOX or via Jet SQL DDL commands.