Error in module when implementing user-level security

[S. Whitney]

[Also posted under Security:]

Today I implemented user-level security on an Access 2000
application we use.

Everything seems OK except for a particular module
designed to fill fields with values from the prior record.*

Now, when accessing the form that calls the module during
OnOpen, I get a MS Visual Basic error: "Compile error:
User-defined type not defined." and the debugger opens
with the following lines highlighted:

Function AutoFillNewRecord(F As Form)

Dim RS As DAO.Recordset, C As Control

I don't think I've changed anything, although to create
the user-level security I had to create a new database and
import all of the objects from the old one.

Thoughts?

Steve Whitney
swhitney at peelmaster dot com

* -- Module was created from code available in
ACC2000: Fill Record with Data from Previous Record
Automatically

http://support.microsoft.com/default.aspx?scid=kb;en-
us;210236

PS -- For any new users having trouble implementing user-
level security based on the help files and FAQ's at
microsoft.com, I strongly suggest the following site:

http://www.geocities.com/jacksonmacd/AccessSecurity.html

 

[S. Whitney]

Never mind. I forgot to re-include a reference to DAO 3.6
in the Visual Basic editor.

Thanks to Scott for his help.

SGW

 

[S. Whitney]

Never mind. I forgot to re-include a reference to DAO 3.6
in the Visual Basic editor.

Thanks to Scott for his help.

SGW