By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Re: Decrypting String / DB

P: 2
Hi Guys,

First Post. Need some help decrypting a String / DB

The company i manage recently had an argument with their lead programmer for their data base. However he has decided to have nothing to do with the company so i cannot contact him to get the info i require.

Ive looked over his computer and accessed the .dat (I have no idea why its a .dat file) file using the password however when i open it up in Access i can view the data with all the tables and fields present however it appears part of the data which actually contains the data is all gobble de gook which i am guessing is because its encrypted.

I had a quick look through his computer and Notes to look for any instructions to decrypt the info however it doesn't mention anything.

However i have found 3 items in his notes which i am sure are Keys to the encryption 2 of which are the same and either 3 could be for the other 2 database files which i need to decrypt. (The encryption property on the file is not set. So i guess the information is encrypted and then stored)


this is what the data currently looks like in table view

Expand|Select|Wrap|Line Numbers
  1. ,,,,,,,,wjtcehwwyjwiF,,qwwjqE yfgjI,wergC efzgcstH .qE,|88733|H|3|F3|yhfzqgsE||FF3 73IF|wjtcehwwyjwiF|hwwyjwiF||qwwjqE yfgjI}!|wergC efzgcstH .qE|{
  2.  
Its supposed to be a clients address with maybe mapping info for plotting on google Maps and other info im unsure of. Ive never worked on this project and don't know much about the foundations of the db however looking at what i got in Access i have many tables with info that needs decrypting that is more sensitive and others which are normal such as dates or client names.

Could anybody please explain to me how i can apply the keys and decrypt the info?

Is there a particular function within access i can call to decrypt my string and get the info?

Ps there are certain functions which he deleted and this maybe one of them and no backups are available.


Appreciate any Help!
Dec 9 '07 #1
Share this Question
Share on Google+
5 Replies


missinglinq
Expert 2.5K+
P: 3,532
I'm confused here; a .DAT file is a data file used by a number of different development languages/applications to store raw data, but it certainly isn't used for any version of Access! Access databases are all inclusive, which is to say everything, data, user interfaces, etc. is all included in one file. If you've somehow managed to open a .DAT file in Access (and I can't imagine how, unless you've changed the file extension) data could certainly exhibit the behavior you've reported.

If, however, this really is a case encrypted data, I'm afraid that giving help on this type of problem is against the policies of this site. After all, we really have no way to know that you actually have a right to this information, and to help when we don't know this would be unethical and possibly illegal. My suggestion would be to contact someone in your area who either develops Access applications or specializes in data recovery. Note that consultants, if legitimate, will require proof that you do, indeed, have a legal right to this application/data.

Linq ;0)>
Dec 9 '07 #2

P: 2
Its ok i understand what you are saying. Like i said i didnt develop the database ive just been asked by my comapany to figure out whats going on. And as i said i already have the password and the encryption keys i just wasnt sure how to apply them.

Any way ill get onto some data recovery guys in the morning to see if they can help figure it out.

Thanks for your help anyway.
Dec 9 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
Good luck!

Linq ;0)>
Dec 9 '07 #4

P: 2
Harb247

It's clear that you are trying to decode the copyrighted and licensed Royal Mail Postal Address File (PAF). This is illegal.

To license a copy of the data, you can visit our website:
http://www.royalmail.com/portal/rm/jump2?catId=400120&mediaId=400084

You will not be able to decrypt this information without the vendor's private key - I have been able to identify the data owner from the data string you pasted in your last post and reported a data breach to them.

Please note that Royal Mail employ a team of people to protect its data rights and we will pursue anyone who is fraudulently trying to obtain our copyrighted information without a licence.

Regards

Malcolm Johnson
Royal Mail
Jan 29 '08 #5

P: 2
Hi Guys,

First Post. Need some help decrypting a String / DB

The company i manage recently had an argument with their lead programmer for their data base. However he has decided to have nothing to do with the company so i cannot contact him to get the info i require.

Ive looked over his computer and accessed the .dat (I have no idea why its a .dat file) file using the password however when i open it up in Access i can view the data with all the tables and fields present however it appears part of the data which actually contains the data is all gobble de gook which i am guessing is because its encrypted.

I had a quick look through his computer and Notes to look for any instructions to decrypt the info however it doesn't mention anything.

However i have found 3 items in his notes which i am sure are Keys to the encryption 2 of which are the same and either 3 could be for the other 2 database files which i need to decrypt. (The encryption property on the file is not set. So i guess the information is encrypted and then stored)


this is what the data currently looks like in table view

Expand|Select|Wrap|Line Numbers
  1. ,,,,,,,,wjtcehwwyjwiF,,qwwjqE yfgjI,wergC efzgcstH .qE,|88733|H|3|F3|yhfzqgsE||FF3 73IF|wjtcehwwyjwiF|hwwyjwiF||qwwjqE yfgjI}!|wergC efzgcstH .qE|{
  2.  
Its supposed to be a clients address with maybe mapping info for plotting on google Maps and other info im unsure of. Ive never worked on this project and don't know much about the foundations of the db however looking at what i got in Access i have many tables with info that needs decrypting that is more sensitive and others which are normal such as dates or client names.

Could anybody please explain to me how i can apply the keys and decrypt the info?

Is there a particular function within access i can call to decrypt my string and get the info?

Ps there are certain functions which he deleted and this maybe one of them and no backups are available.


Appreciate any Help!
Harb247

It's clear that you are trying to decode the copyrighted and licensed Royal Mail Postal Address File (PAF). This is illegal.

To license a copy of the data, you can visit our website:
http://www.royalmail.com/portal/rm/jump2?catId=400120&mediaId=400084

You will not be able to decrypt this information without the vendor's private key - I have been able to identify the data owner from the data string you pasted in your last post and reported a data breach to them.

Please note that Royal Mail employ a team of people to protect its data rights and we will pursue anyone who is fraudulently trying to obtain our copyrighted information without a licence.

Regards

Malcolm Johnson
Royal Mail
Jan 29 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.