Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Security

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-09-2006, 06:25 AM
Novice
 
Join Date: Aug 2006
Location: Upstate NY
Posts: 1
amosstarz
Default Access Question regarding JPEG files

Hi. This maybe a newbie question. I am working on a database for the my employer. Essentially each document that is created within the DB needs to have an electronic signature attached. I call up the electronic signature from a JPEG file.
My problem is that the file and folders are setup as such:

x:/database/db
x:/database/sig_files

I had given complete rights to everyone because pretty much everyone requires access to the DB. However, management is concerned about rights to the electronic signature files. If I change the rights to the signature folder - users that call up documents in the DB cannot see the signatures and of course the signatures do not print. Is there a way to link to the JPEG files securely so that the users can view the signatures in the documents within the DB but not have rights to the actual JPEG files?
Hopefully that makes sense.

Thanks.
Reply With Quote
  #2  
Old 09-01-2006, 02:17 PM
Novice
 
Join Date: Sep 2006
Location: Manchester, England
Posts: 13
DanInManchester
Default

No not really because the database application runs with the current users credenditials and the files are accessed using the same credentials.

you could protect them better storing them in BLOBS but this a practice I avoid.

It's possible you could do something "hacky" through using runas.
If you create an account that has access to the sig files then within the application code use run as to gain access that may work. I'm not convinced this is even possible and it's terribly hacky.

A web based application you allow you to protect these files.
Maybe you could migrate you software to the web or a small part of it.

Also some basic file encryption algo could do it. so essentially you encrypt the files so the user cant access them directly but the application knows how to decrypt them.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
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
Importing Xls and CSV files into MS Access Jeff Import/Export Data 1 02-17-2009 08:56 PM
Question about the future of Access kantell Access 0 11-04-2008 08:43 AM
JPEG isn't displayed in forms GeorgeILPS Access 0 01-14-2008 09:21 AM
How many files/pics can be attached to database? Suzan Access 1 07-09-2006 07:23 AM
Access Relationship Display Question dayrinni Access 3 02-05-2006 08:16 AM


All times are GMT -8. The time now is 08:21 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.