I have found the problem and would like to share it with everyone. I don’t
understand why this fault has occurred but I am confident I have resolved my
issue with my digital certificate.
My access 2003 database kept crashing when opened when I assigned a digital
certificate to my project. Without the digital certificate the database
opened fine.
On creating a new database, the digital certificate worked. So I knew it was
something specific to my database.
Created a new database and slowly imported all my items from my original
database until I found a form that was causing the database crash.
Using a new database with this 1 form, the database crashes. Using my
existing database without this form worked.
Took this form and its code to pieces and was amazed at what I found.
I had 16 boxes all next to each other that created a progress bar. All these
boxes were grouped together. When un-grouped that digital certificate worked
fine. When these boxes were grouped together, the database crashed.
It is very strange and I can’t explain it but my original database now works
fine, since I ungrouped these boxes.
The form in question doesn’t even open when the database opens so I really
can’t explain what has happened, but all is fine now.
Many thanks for your support
"StuJol" wrote:
> i have an Access2003 database. my macro security settings were set to low.
> all worked fine. i have bought and installed a digital certificate from
> thawte and signed my vb code with it. i have adjusted my security level to
> high. my database now crahes everytime i open it.
>
> i created a new database, signed the code, set security to high, when opened
> asked if i trusted the signer, then it opened. all worked fine.
>
> i thought my original database may be corrupted in some way so i created a
> new database, imported everything from my old database but it crashes when
> the security is set to high.
>
> any ideas anyone?
|