Database Crashes

[StuJol]

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?

 

[StuJol]

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