Par2: Runtime encryption of TPS files 2006-08-11 -- Pratik Patel > Create a topspeed file on fly with unique owner name(password) to Store
> each employee's crucial personal information in another database. Thanks
> in advance.
so long use you know the table format, in the dct for that table, assign a
variable to the Owner - say !glo:EmpOwner and !glo:EmpFileName to the
FileName
then in your code prior to opening the table assign your values...
glo:EmpOwner = 'SomeSecurePassword'
glo:EmpFileName = c:\fullpath\...' &'\'& EmpName & '.tps'
access:Employee.Open()
Jeff Slarve adds:
I do something similar, but with another step. By having the literal
'SomeSecurePassword' compiled into your app, it can be easily found
(even though it would not be readily apparent what that string is
for).
So what I is concatenate the owner id at run-time.
e.g.
ABC STRING('ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890')
!123456789012345678901234567890123456
! 1 2 3
Code
MyID = ABC[1] & lower(ABC[20]) & ABC[29]!etc, etc,
Printed April 28, 2024, 6:38 am This article has been viewed/printed 35119 times. |