Help with Digital Signatures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simon@geniecom.fsnet.co.uk - 13 Mar 2006 12:34 GMT

I created an access database and digitally signed it.
I then gave a copy of this Database to a friend.
A few months later he wanted me to make some changes to it so i took an
up-to-date copy from him and opened it on my computer..... but it tells
me the "Visual basic project has been protected with a password".
All web links tell me to open the visual basic editor and select TOOLS
- DIGITAL SIGNATURES.... but the option is not there. if i try to add
it to the toolbar, it doesnt allow me too. Therefore i am stuck

Can anyone help please? much appreciated

Reply to this Message

simon@geniecom.fsnet.co.uk - 13 Mar 2006 14:19 GMT

I spend a LOT of time trying to help others with their access problems
but whenever i post a problem of my own i NEVER get a response.

Please could someone take the time to address my issue, as i do for
other

Thanks

Reply to this Message

Anthony England - 13 Mar 2006 14:57 GMT

>I spend a LOT of time trying to help others with their access problems
> but whenever i post a problem of my own i NEVER get a response.
[quoted text clipped - 3 lines]
>
> Thanks

Although it is frustrating, you will probably find that your TimeSpent to
AttentionReceived ratio is not the highest in the group - some people really
do give up a lot of their free time.
Unfortunately, the answers you might get are not always a function of what a
good newsgroup citizen you have been, but more likely a function of how easy
the question is to solve. You will get many, many people here who although
they may be highly knowledgeable with data access methods and vba, have
never needed to digitally sign projects. Or if they have, they have never
had this issue with them.
I'm not sure exactly what the problem is here, but I know that I had one
swapping the version of Access. If you digitally signed it, then I guess
the idea was to stop people fiddling with it - so can you not take the
original you gave him and simply import his updated data? Or do you believe
he has modified more than the data?

Reply to this Message

Terry Kreft - 13 Mar 2006 16:55 GMT

That's interesting because a google search for you brings back 10 results,
each one of them asking for help rather than offering it.

Maybe I'm looking in the wrong place (?).

Signature

Terry Kreft

> I spend a LOT of time trying to help others with their access problems
> but whenever i post a problem of my own i NEVER get a response.
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Tom van Stiphout - 13 Mar 2006 15:04 GMT

Tools / Digital Signature is on the VBA side, not on the Access side.
Open a code window and try again.

Applying a DS has nothing to do with the database password. So you
have a few options:
* Ask your friend for the password
* Go back to a backup of the project from before you gave it to him
* Try to crack the password using some "reveal pw" software available
on the internet

From your description I think you may have written a monolithic
application rather than split it in FE/BE. Bad choice.

-Tom.

>I created an access database and digitally signed it.
>I then gave a copy of this Database to a friend.
[quoted text clipped - 6 lines]
>
>Can anyone help please? much appreciated

Reply to this Message

simon@geniecom.fsnet.co.uk - 13 Mar 2006 15:30 GMT

Tom, As i stated above, the "DS" option is not available in the Visual
Basic Editor. The database doesnt actually have a password either. i
can get into the database but i cannot view any code.

I dont have the original copy so i can only work from what i take from
him, but i cant import it into a new DB either, it doesnt allow it.

Reply to this Message

salad - 13 Mar 2006 18:11 GMT

> I created an access database and digitally signed it.
> I then gave a copy of this Database to a friend.
[quoted text clipped - 6 lines]
>
> Can anyone help please? much appreciated

I thought one could put a password onto VBA code in A2000 and more
recent versions.

Perhaps someone was playing around with the code and saved it and added
as password. This wouldn't have much to do with a digital signature
(IMO), more something to do with the developer or end-users that
can/could get into code modules and set a password.

I think if you open a blank database, create a code module, if you hunt
on the menu you'll see a place where you can put a password.

See if you can google around and find something on VBA module password
remover.

See if this link assists any
http://www.tucows.com/search?search_terms=vba+module+password+protection&search_
scope=win&search_adv=0&search_size=&search_size_multi=b

Reply to this Message