Assigning User Passwords - User-Defined Type Not Defined error

Assigning User Passwords - User-Defined Type Not Defined error

Post by TWFjTnV0Mj » Sat, 11 Mar 2006 01:39:06


Hello,

I have created a secure database using the User-Level security wizard with
success. Right now, I am trying to assign passwords using functions...and
i'm using this line of code:
Dim cat As ADOX.Catalog
and I get an error saying "User-Defined Type Not Defined" at runtime and
don't know what that means. Can someone help me?

Thank you!
MN
 
 
 

Assigning User Passwords - User-Defined Type Not Defined error

Post by Joan Wil » Mon, 13 Mar 2006 01:12:27

Do you have a reference set to Microsoft ADO Ext. 2.7 for DDL and Security?
(Tools, References)

That said, it is my understanding that ADOX is incomplete/buggy and doesn't
work for some things. Is there a reason you aren't using DAO instead?
Lookup NewPassword method in Help.


--
Joan Wild
Microsoft Access MVP