Software

Ask something
Discussion Locked

Securing an Access DB

0 helpful
3 replies

by emkay_mm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi guys,

how can i make my access 98 / 2000 db secure, besides using the password- for what if a user gets hold of the password ?

i have to send this db with an application, on a CD.

Any other means of securing my access db, so that it becomes inaccesible, by direct clicking, or cannot be opened in access, even if the password is known to the other user?

please help
thanx

3 replies

by donq

Securing an Access database has many features similar to midrange and mainframe database products, and is quite state-of-the-art! Users, Groups, and Permissions can each be created, assigned, deleted, and/or mixed.

A secure Access database is one operating within its own Workgroup (or something similar to a PC session). This named workgroup stores group, user, and permission values outside Access in an independant file everyone opening the secured database must have on his/her idividual PC. The process is complex and in my opinion way beyond any 400 point (or 10000 point question). MANY things MUST be done in an orderly logical step-by-step procedure either through the Securrity Wizard or manually and you MUST know where you are going because the last step locks the person creating the .mdb file and security system out!! For sure read and understand all about Workgroups, Users, Groups, Permissions, and database Objects and make an unsecure backup BEFORE you begin.

This discussion is closed to new replies.