How can i restrict access to my database

  • Thread starter Thread starter Silvia Zamora
  • Start date Start date
S

Silvia Zamora

Hello, i'm developing a system and i need my database to be in a server, so
no one can have access to it for messing up with the data. Can any one help
me with this?, i'm almost new at using Access.
 
Dear Silvia,

After You Open A New Database Go To Tools – Security - User And Group
Accounts, Create New 2 Users One Of Them Will Be An Admin That Is You, And
The Other Will Be Just A User Has Certain Permissions,
Then After Creating These 2 Users Go To Tools - Security - User And Group
Permissions, You Will Find At The Right Side The Object Type Menu, From
Database To Macro, Choose One By One And Assign The Permissions For Each
User, You Need To Click On Apply After Any Change For Each User For Each
Object Type.
After You Finish Please Check Again That All The Permissions For Each User
For Each Object Type, Then Go To Toos – Security – Workgroup Administrator,
You Will Find Your Name And Company And Workgroup That Point To A Path For A
Security File Called System.Mdw Or Security.Mdw, You Need To Keep This File
In Safe, Because You Will Not Be Able To Work In Your Data Base If You Lost
This .Mdw File,
For Me I Take A Copy Of It In My Documents And I Change The Path In The
Workgroup By Clicking On Join, But If You Copy Your Database File To Any
Other Computer It Will Not Work Until You Join The Microsoft Access Workgroup
To Your .Mdw File That Obviously You Will Copy It Too With Your Database
File, So You Need Your Database File To Be Side By Side With The .Mdw
Good Luck
 
Silvia said:
Hello, i'm developing a system and i need my database to be in a
server, so no one can have access to it for messing up with the data.
Can any one help me with this?, i'm almost new at using Access.
Click to expand...

If you want to secure your database, don't follow the steps outlined by Abgr
Xenda.

I don't think you need to implement security though. It sounds as though
only you will use this database and no one else is to use it, correct?

Just put it in a folder on your server that only you have permissions to.
 
Thank you for your help, i'm still a little confused, the DB will be in a
sever because the proyect it's for a large company, and the porpouse of the
DB being in the server it's that those who enter the system won't be able to
modify the data that's already on the DB, they only have the chance to add
data to it. As i see it should work like SQL.
 
Silvia said:
Thank you for your help, i'm still a little confused, the DB will be
in a sever because the proyect it's for a large company, and the
porpouse of the DB being in the server it's that those who enter the
system won't be able to modify the data that's already on the DB,
they only have the chance to add data to it. As i see it should work
like SQL.
Click to expand...

People who are allowed to use an Access file share will always be able to
destroy it. If that is not acceptable then don't use an Access/Jet file to
store the data.
 
Dear Silvia,

in that part i explain the steps to assign the permissions for each user you
will be able to choose who can add only, and who can add and modify, and who
can do what, if there is a way to send to you a programming i create with
access, i will give you 3 user name for admin and a user can add and a user
can add and modify

hope it help you
 
Back
Top