mshmyob
Last Activity: Jul 15 '24, 02:45 PM
Joined: Jan 7 '08
Location: witness protection
-
Good to know. Thanks for the update -
You are correct Rabbit but I want to see if I hash it with a hidden salt (I will encrypt The salt) and have it on a different server. That way if the database gets compromised all they will know is that one of the encrypted columns (they won't know which one) contains like data in some rows. But without the salt they will not be able to determine the prefix which is the actual data.Leave a comment:
-
Actually with some more research I think I came up with the solution of how to query encrypted data without first decrypting and then iterating through the data with application code.
I can directly query the encrypted data with the concept of Blind Indexing. I think I will try this route.
ThanksLeave a comment:
-
Hey Neo, not promising anything to anybody. I am doing this all for myself to get a better understanding of encrypting a database without built in tools. I really want to know the details.Leave a comment:
-
So assume I have a table with 5 columns
col1 - primary key - auto generated - Not encrypted
col2 - text - encrypted
col3 - text - encrypted
col4 - text encrypted
col5 - IV column - unique for each row - obviously not encrypted
Assume col4 has just contains single words. Now I execute the following simple query
I can...Code:SELECT * FROM tablename WHERE col4='Apple';
Leave a comment:
-
Thanks. I am going to use pre built functions for encryption (the paid functions for Sqlite) do it field by field so I can just do that myself. I did find an article talking about binary fields and such. Just because this is my own pet project I would like to try just to get more knowledge.
Thanks for the feedback.Leave a comment:
-
Hey NEO,
Long time... I am not using a MS Access database. This is a pet project that I am working on. I am using an SQLite database and Python. There are addons to buy for encryption for SQLite but I do not want to pay for them. I have the code for Python to do all the encryption and decryption and I think I have a proper method to hide the keys but I am stuck on the concept of saving and retrieving the encrypted/decrypted data...Leave a comment:
-
Encrypting a database
This is NOT a question regarding coding, it is a question concerning methodology.
I need to encrypt a database. The database being used does not contain any encryption abilities like TDE for SQL Server. I have therefore worked out a method to do symetric encryption and key storage etc.
My question is which method should I use for the encryption/decryption and executing SQL statements.
I am thinking to... -
If I am reading this correctly then you have a many to many relationship not a 1 to many. If Seth Schrock can be a partner in the company Seth Schrock and Schrock Farms then you have a many to many since a company can also have more than 1 partner.Leave a comment:
-
I do not use Act anymore but it has an export feature. I believe under File - Data Exchange - Export you can then export the records and fields that you want as a comma delimited file. You can then import this file into Access.
cheers,Leave a comment:
-
Sure. Post what you have done and give me more details of what you want and I will see what I can do to help.
cheers,Leave a comment:
-
I threw this together.
The code only checks for the 1st character entered so you would have to fine tune it for more detailed matches.
Error handling was put in because of how Access handles entries where no value exists in the list.
You need a hidden field so you can move to it to requery your combobox.
If you want to get the entire list back again just delete all characters and the complete list...Leave a comment:
-
I believe you are correct. I do not believe you can actually overwrite the PK autonumber value in the Orders table. If anything the system created a new record and copied the data and then deleted the original record somehow.
Without more information it would be hard to analyze.
Could you at a minimum supply the schema for your Order table and Order Update table along with any bridge tables, rules etc.
Ch...Leave a comment:
-
Because Access does not have a RANK function you have to create your own as suggested.
The following displays the student name, the average and the ranking. In this scenario the student name and averages are stored in a table called tblScores.
You would need to change table names and field names as required.
...Code:SELECT tblScores.StudentName, tblScores.StudentAvg, (SELECT Count(*) FROM tblScores AS
Leave a comment:
-
Make your field an Autonumber type.
cheers,Leave a comment:
-
If he uses the runtime then he does not need to concern himself with licensing issues. The Runtime starting with Access 2007 is free and has no licensing restrictions.
You still need at least one legit copy to develop your app with.
cheers,Leave a comment:
-
An ETL (Extract Transform Load) tool is an application like SQL Server Integration Services (SSIS). But as Seth points out you need to show us where you are having the problem. I don't think anybody here is going to attempt to write a generic ETL tool that can accommodate all possible scenarios or functionality of a tool like SSIS.
cheers,Leave a comment:
-
@z
I have never heard that a TDE enabled database needs an encrypted connection string. I am also assuming his database is just encrypted and not the transmission link using something like IPSec or some other transmission encryption/decryption protocol.
So I still stand behind my previous post unless you can show otherwise.
cheers,Leave a comment:
-
@seth
I have not read all the links posted and I quickly looked at your link.
The encryption that is used by SQL Server is called TDE (Transparent Data Encryption). All the encryption and decryption is actually done by the SQL Server Database Engine and the client should be irrelevant (hence Transparent).
The users who access the Server Instance should automatically see the decrypted data if they have the proper...Leave a comment:
-
You only need a single INSERT statement.
cheers,Code:sql = "INSERT INTO Passwords (Passwords, Names) VALUES ('" & LName & "','" & LNa & "')"Leave a comment:
No activity results to display
Leave a comment: