Login
`
Templates, Tools and Utilities
|
||
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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,
Today is November 21, 2024, 8:21 am This article has been viewed 35224 times.
|
|