How do they work? Usually when you try to expend protected VBA project you will be prompted for a password. For example Unviewable+ or Secure++ – both created by Petros Chatzipantazis from. So is there a way to lock your VBA project for good? Yes, there is. I have described two of them on my blog – here and here. There are several methods or third-party software that can crack this protection in seconds. But is your code really safe now? No, it’s not. Last edited by June7 10-09-2013 at 02:09 PM.You may think it’s easy – just open VB Editor (ALT + F11), go to Tools > VBAProject Properties…, switch to Protection tab, check Lock project for viewing, set a password, hit OK and save your file. I googled the error message and attempted a few fixes:Īdding/removing a digital certificate, both no luck.ĭecompiling(?) and debugging the database and that didn’t work either (this actually broke it and then I had to re–transfer the database)Īny help is much appreciated!! The employee who currently works on this process is leaving the company Friday and I wanted to be sure to have a running database for processing come Monday. I can’t seem to access it because when I attempt to view the code in the VBA editor screen I receive the error message “Project is not available.” I’m not sure what safe guards (if any) the previous developer placed on this but I cannot seem to view the code. The issue is when I go into the developer mode and attempt to look at the VBA code for the modules. To correct the possible error, I tried to view the VBA code. I think that a link (to our shared drive) in one of the modules may be broken. Almost being the key word, because the final step to the database is exporting the report to excel and this is the step that is not functioning. mdb extension.Īfter the transfer, I can open, close and run almost all of the needed functions. It was originally created on Access 2003 and I currently have 2010. I’m a bit of a novice and I personally did not program this database, it is from my predecessor so I'll do my best at explaining the issue. Hi, I’m having an issue with a transferred database. I did not save them otherwise I would post it along with my response. I truly have no idea what it means, but I tried the steps that they outline. What I mean by ‘decompiling”: I read a few online forum answers where people have had similar problems and decompiling and debugging was among them. I transferred 2 databases, the other database allows me to view and edit the VBA, and this one does not. I can’t seem to access it because when I attempt to view the code in the VBA editor screen I receive the error message “Project is not available.” I’m not sure what safe guards (if any) the previous developer placed on this but I cannot seem to unlock the code. To correct it I tried to view the VBA code. It appears that a link in one of the modules may be broken. Almost being the key word, the final step to the database is exporting the report to excel and this is the step that is not functioning. I can open, close and run almost all of the needed functions. To clarify the issue isn't in opening the database. Also a side note, I personally did not program this database, it is from my predecessor. Hi June7, thanks for your response! Due to corporate policy I cannot upload the database so I'll do my best at explaining the issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |