Solved

Setting up a EFS

Posted on 2004-10-01
5
165 Views
Last Modified: 2013-12-04
Hi there everyone,

I am working with an windows 2000 server network. I have a file server where we keep all the ms access databases on users on my network access and work on these databases. This file server is then backed up every night to tape.

What I want to do is encrypt all these access databases perphaps using EFS or something like it. I understand that if you use EFS then you have access to the to the encrypted files but no one else does.

How do I enable other users on my network to have access to them? Can someone point me in the right direction?

I am thinking that it will mean installing a key on the users machines that I want access the file server.

Any help would be greatly appreciated.

Eddy
0
Comment
Question by:teched1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 57

Expert Comment

by:Pete Long
ID: 12198427
Eveytime Ive applied EFS to an Access database it hasnt run properley? why not just use NTFS folder permissions?
0
 

Author Comment

by:teched1000
ID: 12198692
Hi Petelong,

Thanks for the quick responce.

Really? Thats useful info about encrypting access databases.

I could have already edited the permissions so that only the users I want have access.

But I thought about putting in an extra layer of security with Encryption but I don't want to be corrupting any databases.

I have noticed that when in access you can encrypt a another access database. But we have thousands of databases.

Eddy
0
 
LVL 57

Accepted Solution

by:
Pete Long earned 200 total points
ID: 12201334
Hi Eddy

I saw the question come through - and remembered having problems, so I asked the database developers why

and got a "Oooh dont do that" so I asked why? and got no discernable sensible answer if you have thousands of access data bases perhaps its time to look at SQL?
0
 
LVL 3

Assisted Solution

by:Gargantubrain
Gargantubrain earned 50 total points
ID: 12241082
EFS only allows ONE user to access the file (plus the recovery agent). For a database file you expect to access from multiple users, it would not work except for the user who encrypted it in the first place.
0
 
LVL 57

Expert Comment

by:Pete Long
ID: 12465636
ThanQ
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: btan
The intent is not to repeat what many has know about Ransomware but more to join its dots of what is it, who are the victims, why it exists, when and how we respond on infection. Lastly, sum up in a glance to share such information with more to help…
Security measures require Windows be logged in using Standard User login (not Administrator).  Yet, sometimes an application has to be run “As Administrator” from a Standard User login.  This paper describes how to create a shortcut icon to launch a…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question