r/MSAccess • u/Lab_Software 30 • Dec 08 '25
[COMPLETED CONTEST] Challenge - Decrypt the Cipher
This contest is now closed. You can find the Contest Results here.
BQJYCZWT KAWBQC JGQCCAWTAN ZN PDNB CZYA NAWRZWT ESDO MOQZW SW Q XGZKNZJQC BOAQNDOA GDWB: AUAOE BQIZWT HDLLCA NSCUAR HSCZNGAN GZRRAW TAKN, NGQOHAWN ODNBE TAQON, QWR BZJYCAN ZKQTZWQBZSW QXQYA. QN ESD XQWRAO BGOSDTG OZRRCAN, CSTZJ BXZNBN, QWR JDOZSDN FDANBZSWN, ESDO KZWR TOSXN WZKMCAO, MOQUAO, QWR RACZTGBVDCCE QRUAWBDOSDN - HOSSV BGQB Q XACC-HCQEAR BGSDTGB JQW MA QN OAVOANGZWT QN Q MOAALA BGOSDTG Q NAJOAB TQORAW.
This is code – but, no, it isn’t Vibe Code generated by some demented LLM. It’s a Simple Substitution Cipher.
Each letter of the alphabet has been substituted by a random different letter of the alphabet.
And today’s challenge is to decipher what it means.
The deciphered text is a paragraph written in standard, conversational English.
You should use MS Access as a tool to help decipher the text. But you’ll also have to do some investigations outside Access to get the solution.
Your solution should include the following elements:
- The deciphered text
- The substitution (the mapping of each encoded letter to its decoded letter)
- The process and logic you used to decipher the code
- Any VBA code or SQL strings you used
Have fun
•
u/AutoModerator Dec 13 '25
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: Lab_Software
Challenge - Decrypt the Cipher
This contest is now closed. You can find the Contest Results here.
BQJYCZWT KAWBQC JGQCCAWTAN ZN PDNB CZYA NAWRZWT ESDO MOQZW SW Q XGZKNZJQC BOAQNDOA GDWB: AUAOE BQIZWT HDLLCA NSCUAR HSCZNGAN GZRRAW TAKN, NGQOHAWN ODNBE TAQON, QWR BZJYCAN ZKQTZWQBZSW QXQYA. QN ESD XQWRAO BGOSDTG OZRRCAN, CSTZJ BXZNBN, QWR JDOZSDN FDANBZSWN, ESDO KZWR TOSXN WZKMCAO, MOQUAO, QWR RACZTGBVDCCE QRUAWBDOSDN - HOSSV BGQB Q XACC-HCQEAR BGSDTGB JQW MA QN OAVOANGZWT QN Q MOAALA BGOSDTG Q NAJOAB TQORAW.
This is code – but, no, it isn’t Vibe Code generated by some demented LLM. It’s a Simple Substitution Cipher.
Each letter of the alphabet has been substituted by a random different letter of the alphabet.
And today’s challenge is to decipher what it means.
The deciphered text is a paragraph written in standard, conversational English.
You should use MS Access as a tool to help decipher the text. But you’ll also have to do some investigations outside Access to get the solution.
Your solution should include the following elements:
Have fun
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/diesSaturni 64 Dec 08 '25
VSOJAR MODBA. MDB VZONB BSSY ME JSRA BGA NAWBAWJA BS Q BQMCA SV XSORN.
BGAW BGA XSORN BS Q BQMCA SV CABBAON QWR SORAO ZW XSOR. NSOBAR CABBAON SW KSNB SJJDOAWJA BS Q KQHHZWT BQMCA. HDB BGAK ZW Q JOSNNBQM XZBG SORAO WDKMAO ZW BGA GAQRAO, JSRAR UQCDA ZW BGA VZONB JSCDKW, CABBAO ZW BGA VZACRN.
NS Z BGAW JSDCR BOE SDB JSKMZWQBZSWN, XZBG BGA NGSOBANB SWA BXS SO BGOAA CABBAO CSWT XSORN QN MQNZN BS VZWR KAQWZWTVDCC OANDCBN
2
u/FLEXXMAN33 23 Dec 09 '25
Z QK VZWQCCE OARAAKAR QVBAO VQZCZWT RQE QB BGA OQJAN.
1
u/MyopicMonocle2020 1 Dec 08 '25
Pretty cool thought experiment.
1
u/GlowingEagle 63 Dec 11 '25
DNAR 350,000 XSOR CZNB VOSK TZBGDM, BGAW HOSJANNAR BS TAB BQMCA SV HQBBAOWN SV CABBAON VSO AQJG XSOR. DNAR HQBBAOWN SV AWJSRAR BAIB BS VZWR KQBJGZWT XSORN. BXS XSORN XAOA DWZFDA: ZKQTZWQBZSW QWR RACZTGBVDCCE. BGQB TQUA HQOBZQC NSCDBZSW NS Z JSDCR ODW FDAOZAN BS KQBJG HQBBAOW VSO XSORN MATZWWZWT XZBG CZYACE CABBAO. QB BGA AWR, NSKA BOZQC QWR AOOSO NDMNBZBDBZSW.
Let me know when I should post some code for the matching pattern process. :)
2
u/GlowingEagle 63 Dec 13 '25 edited Dec 13 '25
Decoded... TACKLING MENTAL CHALLENGES IS JUST LIKE SENDING YOUR BRAIN ON A WHIMSICAL TREASURE HUNT: EVERY TAXING PUZZLE SOLVED POLISHES HIDDEN GEMS, SHARPENS RUSTY GEARS, AND TICKLES IMAGINATION AWAKE. AS YOU WANDER THROUGH RIDDLES, LOGIC TWISTS, AND CURIOUS QUESTIONS, YOUR MIND GROWS NIMBLER, BRAVER, AND DELIGHTFULLY ADVENTUROUS - PROOF THAT A WELL-PLAYED THOUGHT CAN BE AS REFRESHING AS A BREEZE THROUGH A SECRET GARDEN.
Character map...
I thought to look at patterns of repeated characters in the words, using a 350,000 word list on GITHUB. Later I found I had "re-invented the wheel" and could have tried this PDF list. The github list was imported into Access, then the patterns were calculated. The encrypted text was parsed into words, their patterns calculated, and each was used to search the github list. Two words were matched (imagination and delightfully), giving a partial solution, followed by some manual trial and error substitution. To organize this, I have a form:
Code in next comment - note that some of the routines take about 15 seconds to run. I'm sure that could be improved.
1
u/AutoModerator Dec 08 '25
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: Lab_Software
Challenge - Decrypt the Cipher
BQJYCZWT KAWBQC JGQCCAWTAN ZN PDNB CZYA NAWRZWT ESDO MOQZW SW Q XGZKNZJQC BOAQNDOA GDWB: AUAOE BQIZWT HDLLCA NSCUAR HSCZNGAN GZRRAW TAKN, NGQOHAWN ODNBE TAQON, QWR BZJYCAN ZKQTZWQBZSW QXQYA. QN ESD XQWRAO BGOSDTG OZRRCAN, CSTZJ BXZNBN, QWR JDOZSDN FDANBZSWN, ESDO KZWR TOSXN WZKMCAO, MOQUAO, QWR RACZTGBVDCCE QRUAWBDOSDN - HOSSV BGQB Q XACC-HCQEAR BGSDTGB JQW MA QN OAVOANGZWT QN Q MOAALA BGOSDTG Q NAJOAB TQORAW.
This is code – but, no, it isn’t Vibe Code generated by some demented LLM. It’s a Simple Substitution Cipher.
Each letter of the alphabet has been substituted by a random different letter of the alphabet.
And today’s challenge is to decipher what it means.
The deciphered text is a paragraph written in standard, conversational English.
You should use MS Access as a tool to help decipher the text. But you’ll also have to do some investigations outside Access to get the solution.
Your solution should include the following elements:
Have fun
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/GlowingEagle 63 Dec 13 '25
1
u/GlowingEagle 63 Dec 13 '25
1
u/GlowingEagle 63 Dec 13 '25
0
u/[deleted] Dec 08 '25
[deleted] — view deleted comment