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
teched1000Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Pete LongConnect With a Mentor Technical 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
 
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
 
GargantubrainConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.