adox and mdb properties

[conniek]

I am using adox to create a new mdb database. How do I add a password to open the mdb and make the file hidden?

Set cat = New ADOX.Catalog
    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath & ";Jet OLEDB:Engine Type=" & DBVersion
    Set cat = Nothing

[dee-u]

To set a password just add...

Set cat = New ADOX.Catalog
    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath & ";Jet OLEDB:Engine Type=" & DBVersion [B]& ";Jet OLEDB:Database Password=password[/B]
    Set cat = Nothing

To hide a file have a look at this...

[conniek]

I get the following error when I added that password code:
Could not find installable ISAM.

[Hack]

I get the following error when I added that password code:
Could not find installable ISAM.

Have a look at this.

Or, try this.
'