DaLiMan Posted April 8, 2018 Share Posted April 8, 2018 (edited) HI guys, I'm trying a copy an MS Access file with sensitive data. So I thought I could use _Crypt_EncryptFile. However when I decrypt it again it somehow becomes corrupt. It opens fine, but then crashes when I try to view the tables. I also found this topic from years ago, but that's not working for me with access 2016. I can make a connection to it with "=Microsoft.ACE.OLEDB.12.0" but cannot find if it has a copy with decryption like JET did. Anyone has any ideas that could help me? Edited April 9, 2018 by DaLiMan Link to comment Share on other sites More sharing options...
Developers Jos Posted April 8, 2018 Developers Share Posted April 8, 2018 Just use something like the 7zip commandline to zip and protect the file with a password. Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
DaLiMan Posted April 8, 2018 Author Share Posted April 8, 2018 1 hour ago, Jos said: Just use something like the 7zip commandline to zip and protect the file with a password. Jos Still strange the function _Crypt_EncryptFile() corrupts the DB. I wonder why, do you have any clou on this? But the 7zip commandline works for my local test file. So I'll propably go with this one. Link to comment Share on other sites More sharing options...
jchd Posted April 9, 2018 Share Posted April 9, 2018 You must be somehow misusing the function, or the decrypt one. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
DaLiMan Posted April 9, 2018 Author Share Posted April 9, 2018 13 hours ago, jchd said: You must be somehow misusing the function, or the decrypt one. Also tried the demo(s) from the help file. But it gives me the same problem. Link to comment Share on other sites More sharing options...
Developers Jos Posted April 9, 2018 Developers Share Posted April 9, 2018 Which AutoIt3 version are you running? Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
DaLiMan Posted April 9, 2018 Author Share Posted April 9, 2018 Running Autoit 3.3.14.2 Link to comment Share on other sites More sharing options...
jchd Posted April 9, 2018 Share Posted April 9, 2018 Help file examples encrypt/decrypt do work for me. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
DaLiMan Posted April 9, 2018 Author Share Posted April 9, 2018 6 minutes ago, jchd said: Help file examples encrypt/decrypt do work for me. That's strange. Are you running another version ? And could that be the cause? But after messing with 7zip commandline, I see there is another benefit I have not thought of and involves the reason why zip files exist. It shrinks my backup with an amazing factor. Link to comment Share on other sites More sharing options...
jchd Posted April 9, 2018 Share Posted April 9, 2018 I'm currently running 3.3.14.5 but I don't remember a recent bug fix in previous versions wrt Crypt.au3 Of course encryption doesn't change (significantly or at all) the file size, but zip-ing it has an obvious impact on such compressible data. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
DaLiMan Posted April 9, 2018 Author Share Posted April 9, 2018 14 minutes ago, jchd said: I'm currently running 3.3.14.5 but I don't remember a recent bug fix in previous versions wrt Crypt.au3 Of course encryption doesn't change (significantly or at all) the file size, but zip-ing it has an obvious impact on such compressible data. Okay, so the problem for crypt should be on my PC. But I'll just stick with 7zip for he extra benefits. Thanks all for replying and helping. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now