I GET ERROR WHEN CLICK ON CANCEL VBA PASSWORD PROMPT

[Ami Dalwadi]

TO
HI, EVERYONE

PLEASE HELP ME ON THIS :

1.WE HAVE MS ACCESS 2002 FILE NAMED AS TEST.MDB

2.WE HAVE SOME VBA CODE IN IT

3.WE HAVE SETUP PASSWORD FOR VBA CODE FOR THIS

4.WE ALSO HAVE SETUP USER LEVEL SECURITY ON IT

5.WE HAVE SPLITTED THIS AS FRONT END AND BACK END AND
MADE A LINK TO BACK END TABLES.

6. EVERY THIS IS RUNNING FINE, I CAN LOG ON AS DIFFERENT
USER AND BASED ON USER IT WORKS FINE

BUT

WHEN WE TRY TO OPEN VBA CODE, IT ASK ME PASSWORD, SO,

IF WE PRESS CANCEL THEN TRY TO CLOSE TEST.MDB THEN

IT GENERATE SOME UN EXPECTED ERROR AND SAYS : MS ACCESS
GENERATE ERROR...THEN IT WILL SHOW SCREEN TO REPAIR MS
ACCESS DB AND SEND REPORT....

IF WE TYPE PASSWORD AND PRESS OK AND THEN CLOSE TEST.MDB
THEN IT GOES OK....

IS IT HAPPENING DUE TO MY USER LEVEL SECURITY ?

PLEASE REPLY ME AT
(e-mail address removed)

 

[Joan Wild]

1.WE HAVE MS ACCESS 2002 FILE NAMED AS TEST.MDB

2.WE HAVE SOME VBA CODE IN IT

3.WE HAVE SETUP PASSWORD FOR VBA CODE FOR THIS

WHEN WE TRY TO OPEN VBA CODE, IT ASK ME PASSWORD, SO,

IF WE PRESS CANCEL THEN TRY TO CLOSE TEST.MDB THEN

IF WE TYPE PASSWORD AND PRESS OK AND THEN CLOSE TEST.MDB
THEN IT GOES OK....

IS IT HAPPENING DUE TO MY USER LEVEL SECURITY ?

There really is no need to shout at us (lay off the capslock please).

It has nothing to do with user level security. You placed a password in the
VBA IDE window; so now you must supply the password in order to access your
code.

If you don't want the password, then go in and unset it.