• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

Setting up a EFS

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
teched1000
Asked:
teched1000
  • 3
2 Solutions
 
Pete LongTechnical ConsultantCommented:
Eveytime Ive applied EFS to an Access database it hasnt run properley? why not just use NTFS folder permissions?
0
 
teched1000Author Commented:
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
 
Pete LongTechnical ConsultantCommented:
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
 
GargantubrainCommented:
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
 
Pete LongTechnical ConsultantCommented:
ThanQ
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now