Open the database file in any HEX Editor of your choosing.įind any and all occurrences of the term DPB= and change the B to another value (many tutorials suggest x, but it doesn’t seem to truly make any difference) Never work with the original database file just in case anything goes wrong. Make a copy of the database in question and only work with the copy. I was surprised to find that there was an incredibly simple hack that can unlock any Access password protected VBA project and I figured I’d share in case it could help others. Last edited by June7 10-09-2013 at 02:09 PM.I recently needed to unlock an Access VBA Project for which my client had lost the password. 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 |