Problem with module after implementing user-level security

[S. Whitney]

[Also posted under Modules:]

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?

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

 

[Scott McDaniel]

Your new database probably doesn't contain a reference to DAO. Check it and
see.

 

[TC]

The other respondent has the answer.

[Also posted under Modules:]

Good for including that warning. However, you have "multi-posted" your
question. When you multi-post, the people reading this newsgroup, can not
see any answers you got in other newsgroup - and vice versa.

It's much better to CROSS-post. This is where you send the same message

once<, to both newsgroups, simultaneously. You do this by including both

newsgroup names, in the Newsgroups line of your newsreader, seperated by
semi-colons (or whatever). Then, all of the answers that are given in this
newsgroup, are instantly visible in the other one - and vice versa.

Cheers,
TC

(snip)