Have you ever tried to send a string variable to MS Access that had apostrophes embedded within an SQL Statement? If YES you will get a run time ERROR. Here is your solution, a function that formats the variable before sending it to the database.
Code: ( text )
Public Function Apostrophe(sFieldString As String) As String
If InStr(sFieldString, "'") Then
Dim iLen As Integer
Dim ii As Integer
Dim apostr As Integer
iLen = Len(sFieldString)
ii = 1
Do While ii <= iLen
If Mid(sFieldString, ii, 1) = "'" Then
apostr = ii
sField ……
Access Denied While Signing Assembly
Description as following,
Cryptographic failure while signing assembly '....' Access is denied.
Solution:
To remedy the problem I simply opened an Explorer window as an administrator and altered the ACLs on the necessary directory. I granted my user Full Control on %ALLUSERSPROFILE%\Application Data\Microsoft\Crypto\RSA\MachineKeys. Simply restart Visual Studio (if it was open) and you should be off and rolling.
validationKey. This specifies the key that the HMAC algorithm uses to make ViewState tamper proof. The validationKey is used when either of the following attributes are set to true:
validationKey. This specifies the key that the HMAC algorithm uses to make ViewState tamper proof. The validationKey is used when either of the following attributes are set to true:
{pages enableViewStateMAC="true"}
{@Page EnableViewStateMac="true"}
decryptionKey. This specifies the key used to encrypt and decryp ……
