Supply password in Visual Basic Editor?

whoever wrote the original VBA code, has added Password protection to the Access ( an internal password, in the VBA and forms, not the external Workgroup password on the MDB).  If you want to change the application, then you will need to get that password from the original developer.

That is precisley what the message is telling you.

AW

Someone passworded the code so that others would not modify it.

Sorry. I was writing at the same time as you.

well...I am the person create the database, but I don't think I put any password on it. Anyway, is there a way to clear/reset the password?

Thanks.

I got this from MS help:

Important:  If you forget your password, it can't be recovered, and you won't be able to view or edit the VBA code.

where can I supply the password?

go to Tools/Project Properties while in VBA and select the protection tab. That is, if you have access to it.

It saying "project is unviewable"
Where can I type the password to unlock the project?

Thanks.

As soon as you attempt to access the VBA coding environment, it should prompt you for that password. If it doesn't, something else may be wrong. When exactly do you get the error message above? Do you get it when you try to access the VBA coding environment?

I got the following message as soon as I tried to access the VBA coding environment. It didn't prompt for password.

"Microsoft helps protect this VIsual Basic for Application Protect with a password. You must supply the password in the Visual Basic Editor before you can perform this operation."

What version of Access are you using?

The database was created by Access 2000. I use Access2000 to open it.

ok..I just remembered something. This database is on the server. couple of my co-workers upgrade from Access 2000 to Access 2003. To avoid the security warning message(when open DB remotely), they installed the digital certificate. I think that might be the reason.

THanks.

You might also want to try one of the many "Passsword Cracker" services available.

Just do a search in Google "Access VBA Password Crack", and see what they have.