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: 209
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

--------------------
With best wishes - Anthony
Go to the top of the page
 
DanielPineault
post Mar 9 2018, 07:54 AM
Post#2


UtterAccess VIP
Posts: 5,982
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).

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
AnthonyMA
post Mar 9 2018, 10:37 AM
Post#3



Posts: 209
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.

--------------------
With best wishes - Anthony
Go to the top of the page
 
AnthonyMA
post Mar 9 2018, 11:02 AM
Post#4



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


Seems happy with 19, so I'll stick to that

--------------------
With best wishes - Anthony
Go to the top of the page
 
John Vinson
post Mar 16 2018, 03:59 PM
Post#5


UtterAccess VIP
Posts: 4,258
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.

--------------------
John W. Vinson
Wysard of Information
Go to the top of the page
 
AnthonyMA
post Mar 17 2018, 07:05 AM
Post#6



Posts: 209
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.

--------------------
With best wishes - Anthony
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th August 2018 - 08:50 PM