msaccess-vcs-addin
msaccess-vcs-addin copied to clipboard
Export of password-protected project gives a lot of errors
I'm using addin version 4.1.0 (big thanks for this release which is awesome and full of stuff I am benefitting from straight away!)
The VBA project for my .mdb file is password protected. Each time I open the .mdb to start working on it I go to the VBA editor and double-click the project node, which prompts me for the password to unlock. Except, often I forget to do this.
When I forget to unlock and then export the database, I get a lot of red errors in the output window. They scroll past too fast to read but the detailed log file has this at the top:
-------------------------------------
Beginning Export of Source Files
3di5_uk_250215.mdb
VCS Version 4.1.0
Full Path: C:\Users\hugh\Desktop\3di5_uk_250215\3di5_uk_250215.mdb
Export Folder: C:\Users\hugh\Desktop\3di5_uk_250215\3di5_uk_250215.mdb.src\
Using Fast Save
25/03/2025 12:28:25
-------------------------------------
Scanning for changes...
No modified db connections found in this database.
No modified project found in this database.
No modified vb project found in this database.
No modified vbe references found in this database.
No modified vbe forms found in this database.
-------------------------------------
ERROR: Unhandled error, likely before `On Error` directive
Error 50289: Can't perform operation since the project is protected. Source: .Unknown.LogUnhandledErrors
-------------------------------------
No modified proj properties found in this database.
No modified saved specs found in this database.
No modified modules found in this database.
-------------------------------------
ERROR: Unhandled error, likely before `On Error` directive
Error 50289: Can't perform operation since the project is protected. Source: .Unknown.LogUnhandledErrors
-------------------------------------
No modified commandbars found in this database.
No modified shared images found in this database.
No modified themes found in this database.
No modified imex specs found in this database.
No modified queries found in this database.
-------------------------------------
ERROR: Error accessing VBComponent for 'Form_SubAnsRptDrugsHistory'
Error 50289: Can't perform operation since the project is protected. Source: modHash.GetCodeModuleHash
-------------------------------------
There are tens or hundreds of errors, one per each form and report. The output window only gives the first line of the error, and not the detailed second line which does appear in the log file.
I guess this is a small feature request: could the tool better report this error in the output window, and also (probably) abort the whole export straight away since there is no point to continue.