weird UserLevelSecurity/Code problem

[daft]

hi guys

Having a strange audit trail problem in Access 97

Basically, I didn't develop the database but have "taken over" after the developer left.

I'm quite experienced with Access, but usually use my own security modules so am not too familiar with the "user-level" security stuff.

Anyway my problem is:

In the "unsecured" database, everything works ok and users can access all forms.

I added an AJB audit trail to the database, which works ok too.

THEN, I created a Workgroup and added the User-Level security.

After doing that, everytime a record is altered, the audit trail module fires and instantly hits an error at the

The error is 'User-defined type not defined', which occurs at the following line:

Dim db As DAO.Database

This is extremely weird, as the error can't really be in the code, since it worked perfectly prior to introducing the User Level Security thing....

I'm thinking it could be a case of "permissions", but not sure what.

Anyone else experienced this before?

TIA!!!

 

[yippie_ky_yay]

Hey daft,

this is usually a reference problem (maybe the code never needed to be executed until your modification).

Try adding the Microsoft DAO 3.6 Object Library reference.

That should hopefully do it! - let us know.

-Sean

 

[daft]

thanks Sean but I've sorted it - not really sure how though! Basically just set up a new workgroup, changed the permissions for users etc and it all worked ok.

I think that it could have just been a permission thing - maybe the code was trying to fire something which the user didn't have permission for and, rather than giving a standard permission error, it 'threw a wobbly' (to use a technical term)

thanks anyway though!