Digital signature questions

[Dale Fye]

Anybody have much experience with digitally signing their Access mdb files?

When I go into the VBA Editor and select the Digital Signature, I get a
dialog that says:

The VBA project is currently signed as
Certificate name: ID Certificate
Sign as
Certificate name: ID Certificate

and contains buttons for Detail, Remove, and Choose.

If I click on Remove, it replaces "ID Certificate" in both of the above
lines with [No certificate]. If I then click the OK button, it closes the
dialog. But when I reopen the dialog, the top Certificant name line says [No
Certificate] but the bottom one displays "ID Certificate", and the Details
button is not visible.

Is this the way it should be working, or should it show [No Certificate] in
both places after I have removed the certificate. If this is not the proper
behavior, how can I fix it? I believe this problem may be contributing to
some database corruption problems I have been having.

 

[a a r o n . k e m p f]

database corruption comes from using Jet and DAO in inappropriate
situations.

Move to SQL Server.

-Aaron

 

[Dale Fye]

I'm using SQL Server, with an mdb front end!

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

database corruption comes from using Jet and DAO in inappropriate
situations.

Move to SQL Server.

-Aaron

Anybody have much experience with digitally signing their Access mdb files?

When I go into the VBA Editor and select the Digital Signature, I get a
dialog that says:

The VBA project is currently signed as
Certificate name: ID Certificate
Sign as
Certificate name: ID Certificate

and contains buttons for Detail, Remove, and Choose.

If I click on Remove, it replaces "ID Certificate" in both of the above
lines with [No certificate]. If I then click the OK button, it closes the
dialog. But when I reopen the dialog, the top Certificant name line says [No
Certificate] but the bottom one displays "ID Certificate", and the Details
button is not visible.

Is this the way it should be working, or should it show [No Certificate] in
both places after I have removed the certificate. If this is not the proper
behavior, how can I fix it? I believe this problem may be contributing to
some database corruption problems I have been having.

--
Dale

email address is invalid
Please reply to newsgroup only.

 

[Fred]

After seeing it in action hundreds of times, I think that "Aaron" is a one
line computer program that automatically answers all Access questions with
"Don't use Access, use SQL instead". I don't think that the program actually
reads the questions.

I'm using SQL Server, with an mdb front end!

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

database corruption comes from using Jet and DAO in inappropriate
situations.

Move to SQL Server.

-Aaron

Anybody have much experience with digitally signing their Access mdb files?

When I go into the VBA Editor and select the Digital Signature, I get a
dialog that says:

The VBA project is currently signed as
Certificate name: ID Certificate
Sign as
Certificate name: ID Certificate

and contains buttons for Detail, Remove, and Choose.

If I click on Remove, it replaces "ID Certificate" in both of the above
lines with [No certificate]. If I then click the OK button, it closes the
dialog. But when I reopen the dialog, the top Certificant name line says [No
Certificate] but the bottom one displays "ID Certificate", and the Details
button is not visible.

Is this the way it should be working, or should it show [No Certificate] in
both places after I have removed the certificate. If this is not the proper
behavior, how can I fix it? I believe this problem may be contributing to
some database corruption problems I have been having.

--
Dale

email address is invalid
Please reply to newsgroup only.

 

[Arvin Meyer [MVP]]

Only a few of the database developers that I know ever bothered getting a
digital signature. Those that have seem to universally regret it because
they've had numerous problems. In today's world, if you distribute later
version Access files as part of a shrink wrapped solution, it might be worth
getting a digital signature. I don't distribute those types of files, and
the clients I work for do not seem to care. Your Mileage May Vary.