Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Database Security

Posted on 2003-03-21
Medium Priority
Last Modified: 2013-12-04
I'm building a database at home for use by several others workers at my place of employment and the database will be placed on a server there.  Do I create the database securty while I'm building the database at home and then move it to the server, or will I need to put the security in place after the database is on the server?   Is the built in MS Access security safe for this type of database.  This database will be storing things like SSN's and only a few workers will be using it but it will be located on a server where several hundered workers have the use of.
Question by:syldania
LVL 11

Accepted Solution

ghana earned 100 total points
ID: 8180077
If this is a MS Access database you can put the database file(s) in a folder on the server with restricted access. Then the built in Windows file system security (NTFS) will prevent unauthorized access.
LVL 12

Assisted Solution

trywaredk earned 100 total points
ID: 8181192
Supply GHANA's advice with built-in Ms Access security.

Wait until you place the database at the server, because you have to use the servers system.mdw-file

Don't copy the servers system.mdw-file to your home-workstation, and do it there.

Any changes on the servers system.mdw-file will be lost, when you copy your system.mdw-file from home-workstation back to the server.

Many Regards

Jorgen Malmgren

:o) Your brain is like a parachute. It works best when it's open

Expert Comment

ID: 9070641
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

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!

Question has a verified solution.

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

As I write this article, I am finishing cleanup from the Qakbot virus variant found in the wild on April 18, 2011.  It was a messy beast that had varying levels of infection, speculated as being dependent on how long it resided on the infected syste…
This is a guide to the following problem (not exclusive but here) on Windows: Users need our support and we supporters often use global administrative accounts to do this. Using these accounts safely is a real challenge. Any admin who takes se…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

564 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