UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Encryption Key Length, Access 2016    
 
   
AnthonyMA
post Mar 9 2018, 07:14 AM
Post#1



Posts: 215
Joined: 15-October 10
From: London, UK


I tried to encrypt my front end / back end database using a 29 digit encryption key. Both front end and back end would open on their own when provided with the key; the key would also allow the re-linking to take place. However, the front end would not open any of the re-linked tables, giving error "Not a valid password". If I reduce the key length (for testing purposes) to four digits, everything works as expected. Does anyone know what the maximum key length is to allow FE/BE operation?

TVM
This post has been edited by AnthonyMA: Mar 9 2018, 07:15 AM
Go to the top of the page
 
DanielPineault
post Mar 9 2018, 07:54 AM
Post#2


UtterAccess VIP
Posts: 6,961
Joined: 30-June 11



I know that in the past I had encountered some issue when I tried to use a long password. I didn't go digging and simply used 10 characters without any special characters (just alphanumeric with different case).
Go to the top of the page
 
AnthonyMA
post Mar 9 2018, 10:37 AM
Post#3



Posts: 215
Joined: 15-October 10
From: London, UK


Thank you, Daniel. Sadly, I don't have time to experiment too much but I've seen an Access recommendation somewhere to make the key 14 or more. Let's hope it will accept at least 14.
Go to the top of the page
 
AnthonyMA
post Mar 9 2018, 11:02 AM
Post#4



Posts: 215
Joined: 15-October 10
From: London, UK


Seems happy with 19, so I'll stick to that
Go to the top of the page
 
John Vinson
post Mar 16 2018, 03:59 PM
Post#5


UtterAccess VIP
Posts: 4,285
Joined: 6-January 07
From: Parma, Idaho, US


What Datatype are you using for the key? It should be Text; the fact that it has a character limit suggests you might be using some kind of Number field.
Go to the top of the page
 
AnthonyMA
post Mar 17 2018, 07:05 AM
Post#6



Posts: 215
Joined: 15-October 10
From: London, UK


Hello John

This is the "Encrypt with Password" facility on the Info menu. You're not given the choice of data type.
Go to the top of the page
 
Louverril
post Jan 30 2019, 07:08 AM
Post#7



Posts: 504
Joined: 29-April 08



Hi,

Just in case any one else is searching for the maximum password you can use to encrypt your backend if you want to refresh/relink with VBA.

I am using Access 2016.

I trialled 20 - it works

21 does not work

Therefore pretty sure the limit is 20.

Although this link says 14:
https://support.office.com/en-us/article/Ac...68-98c1025bb47c

This says 20 and sort of explains why there is a difference:
https://stackoverflow.com/questions/1230650...s-2010-database

--------------------
Cheers!

Allyson
UK North Yorkshire / North East
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th November 2019 - 01:44 PM