Help with compile error for password protected form

[Guest]

I am getting a "compile error: user-defined type not defined" when i try to
open the form i set a password for. I am using the code from
http://support.microsoft.com/?id=209871 and it will not work. It is showing
me that the error is in the code for the event procedure for the OnOpen
property of the form I am trying to password protect. The two lines of code
that are highligthed (as the "user-defined type not defined" are (1) Private
Sub Form_Open(Cancel as Integer) and (2)Dim rs As DAO.Recordset. Please can
some one help me on my compile error.

TB
Access 2003

 

[Guest]

go into a vba module and check tools/references.

if you don't have a DAO object library referenced, this may be your problem.

e.g. "Microsoft DAO 3.6 Object Library"
as long as you've got some version of DAO in there, I wouldn't be overly
concerned about the number - particularly if its 3.5+

 

[Guest]

It work!!!! Thank you so much.

 

[Guest]

It work!!!!! Thank you so much