access 97 security

[danny]

Hey,

I am securing my db and just joined a new workgroup and
secured my db using the user level security wizard.
However, when i try to open the new secured db it goes
straiht into the vb code and gives me following error:

compile error:
User-defined type not defined.

Please help.

Thanks

Danny

 

[Ki Yi [MS]]

Hello,

You may have missing library checked in the referecences window. Open the
database, create a new module, select
Tools - references menu. Uncheck anything that contains word missing in
from the list of reference libraries.

See following kb for more information:

ACC: VBA Functions Break in Database with Missing References [accesskb]

ID: Q160870 CREATED: 11-DEC-1996 MODIFIED: 15-NOV-2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;160870

Ki