Solved

Setting up a EFS

Posted on 2004-10-01
5
162 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
  • 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now