Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    Upstate NY
    Posts
    1

    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.

  2. #2
    Join Date
    Sep 2006
    Location
    Manchester, England
    Posts
    13
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing Xls and CSV files into MS Access
    By Jeff in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2009, 11:56 PM
  2. Question about the future of Access
    By kantell in forum Access
    Replies: 0
    Last Post: 11-04-2008, 11:43 AM
  3. JPEG isn't displayed in forms
    By GeorgeILPS in forum Access
    Replies: 0
    Last Post: 01-14-2008, 12:21 PM
  4. Replies: 1
    Last Post: 07-09-2006, 09:23 AM
  5. Access Relationship Display Question
    By dayrinni in forum Access
    Replies: 3
    Last Post: 02-05-2006, 11:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums