B
biganthony
Hi,
I have a form with all my settings in it for a database that I wrote for work.
The settings form allows the user to export the settings, so they can keep
their settings as a record. This exported file is a simple text file
("settings.txt") with fieldnames. This settings form is based on a settings
table.
I work with someone who takes delight in taking other people's work. To stop
this pest from taking my ideas from the settings file with regards to the
underlying table structure, is it possible to encrypt the data in as it gets
exported by Access? And, is it possible to have the DB decrypt the settings
file if it ever needs to be imported back in following corruption?
I tried the encryption routines found here (
http://authors.aspalliance.com/wizard/A1OtpP1.asp) and when I try encrypting,
I get subscript out of range error. It compiles OK in Access.
I am using Access 2003.
Could anybody suggest a way to encrypt the data? I am using this as an
exercise to learn more about coding, so excuse my limited knowledge in this
area.
many thanks
Anthony
I have a form with all my settings in it for a database that I wrote for work.
The settings form allows the user to export the settings, so they can keep
their settings as a record. This exported file is a simple text file
("settings.txt") with fieldnames. This settings form is based on a settings
table.
I work with someone who takes delight in taking other people's work. To stop
this pest from taking my ideas from the settings file with regards to the
underlying table structure, is it possible to encrypt the data in as it gets
exported by Access? And, is it possible to have the DB decrypt the settings
file if it ever needs to be imported back in following corruption?
I tried the encryption routines found here (
http://authors.aspalliance.com/wizard/A1OtpP1.asp) and when I try encrypting,
I get subscript out of range error. It compiles OK in Access.
I am using Access 2003.
Could anybody suggest a way to encrypt the data? I am using this as an
exercise to learn more about coding, so excuse my limited knowledge in this
area.
many thanks
Anthony