Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Security design help

I'm hoping someone can help me with a design issue I'm facing.

I have some Excel macro code that accesses a Sybase database using
standard Sybase logons, and the code gets logon information (server,
database, userid, password) from a clear text file that is currently
stored in the same directory. I'd like to enforce a higher level of
security so that someone cannot just open up the text file and see the
logon credentials.

I'm thinking of using the Microsoft Cryptographic Provider to encrypt
the file, but I think this would mean an encryption password being
hardcoded into the VBA code, and potentially accessible by users. I
suppose I could password protect the module containing the database
access code, but I was wondering if there is a more elegent way of
implementing what I'm trying to do.

Does anyone have a recommendation about how I could enforce security
relatively easily? Maybe setting up the system in such a way that only
the application could read the file (maybe a digital signature or
something?).

Any suggestions would be most appreciated.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Security design help Inquisitive Excel Discussion (Misc queries) 0 March 14th 06 09:53 AM
Design [email protected] New Users to Excel 5 November 2nd 05 04:18 AM
Design Michael Excel Programming 2 July 22nd 05 09:39 AM
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod Craig Excel Programming 0 March 16th 05 04:53 PM
Enter Excel Design Mode and Exit Design Mode Bill Lunney Excel Programming 0 August 4th 03 07:48 AM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"